DBA Data[Home] [Help]

APPS.WSH_FLEX_PKG_COGS dependencies on SO_PICKING_LINES

Line 275: SO_PICKING_LINES PL,

271: BEGIN
272: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
273: INTO L_COST_SALE_ITEM_DERIVED
274: FROM SO_PICKING_LINE_DETAILS PLD,
275: SO_PICKING_LINES PL,
276: MTL_SYSTEM_ITEMS M
277: WHERE PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
278: AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
279: AND M.ORGANIZATION_ID = PLD.WAREHOUSE_ID

Line 436: SO_PICKING_LINES PL,

432: BEGIN
433: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
434: INTO L_COST_SALE_MODEL_DERIVED
435: FROM SO_PICKING_LINE_DETAILS PLD,
436: SO_PICKING_LINES PL,
437: MTL_SYSTEM_ITEMS M
438: WHERE PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
439: AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
440: AND M.ORGANIZATION_ID = PLD.WAREHOUSE_ID