DBA Data[Home] [Help]

APPS.WSH_FLEX_PKG_COGS dependencies on SO_LINE_DETAILS

Line 240: FROM SO_LINE_DETAILS LD,

236: END IF;
237: BEGIN
238: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
239: INTO L_COST_SALE_ITEM_DERIVED
240: FROM SO_LINE_DETAILS LD,
241: MTL_SYSTEM_ITEMS M
242: WHERE LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
243: AND M.ORGANIZATION_ID = LD.WAREHOUSE_ID
244: AND M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;

Line 402: FROM SO_LINE_DETAILS LD,

398: PRINTLN('L_LINE_DETAIL_ID is not null');
399: END IF;
400: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
401: INTO L_COST_SALE_MODEL_DERIVED
402: FROM SO_LINE_DETAILS LD,
403: MTL_SYSTEM_ITEMS M
404: WHERE LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
405: AND M.ORGANIZATION_ID = LD.WAREHOUSE_ID
406: AND M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;