Use of P_CONC_REQUEST_ID in report?

The concurrent Program manager passes concurrent request id in your report in P_CONC_REQUEST_ID.

When the concurrent manager runs an Oracle Reports concurrent request, it passes the concurrent request id in the P_CONC_REQUEST_ID parameter. When you call the FND SRWINIT user exit in the report's Before Report trigger, the user exit uses the passed request id to query the Oracle Applications context that the concurrent request was submitted in (via the FND_CONCURRENT_REQUESTS table) and then log on with that context. This allows you to use operating specific views, access profile option values, etc within your report. You should also call the FND SRWEXIT user exit in the After Report trigger.

If you try calling the FND SRWINIT user exit in your report without the P_CONC_REQUEST_ID parameter defined as a user parameter on your report, the user exit will fail.

Difference between Discrete and Process manufacturing?

Process	Discrete
Use formulations or recipes.	Use Bills of Materials (BOMs).
A process manufacturer blends in a batch.	A discrete manufacturer assembles along a routing.
Variable Ingredients, by and Co- products	Standard parts, Components
Attribute driven	Part Number driven
UOM are Material Specific	UOM are Each & Piece
Need Lot, Grades, Potency, Shelf- life	Need Serial Numbers, ECN’s
Mixes, Blends, Transforms	Builds, Assembles, Fabricates
Makes “STUFF”	Make “THINGS”

Explain Discrete, Flow and Process manufacturing?

Discrete manufacturing: is distinguished by the production of distinct items that use bills of material and routings to determine costs and lead times.

Examples: Automobile manufacturing, computer manufacturing, dishwasher and washing machine manufacturing, etc.

Flow manufacturing: is also called Lean Manufacturing or JIT(Just-In-Time) and uses the principles of demand flow manufacturing to produce product is required, for customer orders, quickly and to meet the demand exactly on-time.

Usually, in order to use Flow a company needs to have production facilities that subscribe to the principals of Lean Manufacturing. It is necessary to design production facilities so that production lines, resources, machines, and labor are making only what is needed for immediate customer orders.

Process manufacturing: is distinguished by a production approach that has minimal interruptions in actual

processing in any one production run, or between production runs of similar products. This approach produces multiple unique products in relatively small batches flowing through different production operations throughout the factory.

They are normally producing a Product that is "Homogeneous" and equally divided for the convenience of packaging.

Typical examples are Food, pharmaceutical and other batched-based manufacturers such as refineries, wineries, etc.

Drop Ship - Link between SO and PO

select

      Distinct

      pha.segment1, pla.line_num,OOHA.Order_Number,OOHL.Line_Number

from

      OE_DROP_SHIP_SOURCES      ODSS,

      OE_ORDER_HEADERS_ALL      OOHA,

      OE_ORDER_LINES_ALL        OOHL,

      PO_HEADERS_ALL PHA,

      PO_LINES_ALL PLA

where

      OOHA.HEADER_ID        = OOHL.HEADER_ID AND

      ODSS.LINE_ID          = OOHL.LINE_ID AND

      ODSS.HEADER_ID        = OOHL.HEADER_ID AND

      PHA.PO_HEADER_ID      = PLA.PO_HEADER_ID AND

      ODSS.PO_HEADER_ID     = PHA.PO_HEADER_ID AND

      ODSS.PO_LINE_ID       = PLA.PO_LINE_ID AND

      ODSS.PO_HEADER_ID     = 96770 AND

      ODSS.PO_LINE_ID       =211834;