APPS.WSH_FLEX_PKG_COGS dependencies on SO_LINES

Line 310: FROM SO_LINES L,

306: END IF;
307: BEGIN
308: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
309: INTO L_COST_SALE_ITEM_DERIVED
310: FROM SO_LINES L,
311: MTL_SYSTEM_ITEMS M
312: WHERE M.ORGANIZATION_ID = L_ORGANIZATION_ID
313: AND L.LINE_ID = L_ORDER_LINE_ID
314: AND M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;

Line 471: FROM SO_LINES L,

467: END IF;
468: BEGIN
469: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
470: INTO L_COST_SALE_MODEL_DERIVED
471: FROM SO_LINES L,
472: MTL_SYSTEM_ITEMS M
473: WHERE M.ORGANIZATION_ID = L_ORGANIZATION_ID
474: AND L.LINE_ID = L_ORDER_LINE_ID
475: AND M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;

Line 940: FROM SO_LINES

936: END IF;
937: BEGIN
938: SELECT INVENTORY_ITEM_ID
939: INTO L_INV_ITEM_ID
940: FROM SO_LINES
941: WHERE LINE_ID = L_ORDER_LINE_ID;
942: IF (DEBUG_COGS) THEN
943: PRINTLN('L_INV_ITEM_ID = '||L_INV_ITEM_ID);
944: END IF;

Line 1111: FROM SO_LINES

1107: END IF;
1108: BEGIN
1109: SELECT ORG_ID
1110: INTO L_OPERATING_UNIT
1111: FROM SO_LINES
1112: WHERE LINE_ID = L_ORDER_LINE_ID;
1113: IF (DEBUG_COGS) THEN
1114: PRINTLN('L_OPERATING_UNIT = '||L_OPERATING_UNIT);
1115: END IF;

Line 1191: FROM SO_LINES

1187: END IF;
1188: BEGIN
1189: SELECT PARENT_LINE_ID
1190: INTO L_PARENT_LINE_ID
1191: FROM SO_LINES
1192: WHERE LINE_ID = L_ORDER_LINE_ID;
1193: IF (DEBUG_COGS) THEN
1194: PRINTLN('L_PARENT_LINE_ID = '||L_PARENT_LINE_ID);
1195: END IF;