APPS.OZF_ACCT_GENERATOR dependencies on OE_ORDER_LINES_ALL

Line 357: FROM oe_order_lines_all

353: COMMITMENT_ID,
354: SALESREP_ID,
355: INVENTORY_ITEM_ID,
356: ITEM_TYPE_CODE
357: FROM oe_order_lines_all
358: WHERE LINE_ID = p_line_id;
359:
360: CURSOR header_detail_csr(p_header_id in number) IS
361: SELECT HEADER_ID,

Line 372: FROM OE_ORDER_LINES_ALL

368:
369: CURSOR order_line_csr(p_line_id in number) IS
370: SELECT REFERENCE_LINE_ID,
371: LINE_CATEGORY_CODE
372: FROM OE_ORDER_LINES_ALL
373: WHERE LINE_ID = p_line_id;
374:
375: CURSOR order_header_csr(p_header_id in number) IS
376: SELECT ORDER_CATEGORY_CODE,

Line 881: FROM OE_ORDER_LINES_ALL

877:
878: CURSOR item_type_csr(p_line_id in number) IS
879: SELECT LINK_TO_LINE_ID,
880: ITEM_TYPE_CODE
881: FROM OE_ORDER_LINES_ALL
882: WHERE LINE_ID = p_line_id;
883:
884: CURSOR cost_of_sales_acct_csr(p_line_id in number) IS
885: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)

Line 886: FROM OE_ORDER_LINES_ALL OL,

882: WHERE LINE_ID = p_line_id;
883:
884: CURSOR cost_of_sales_acct_csr(p_line_id in number) IS
885: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
886: FROM OE_ORDER_LINES_ALL OL,
887: MTL_SYSTEM_ITEMS M
888: WHERE OL.LINE_ID = p_line_id
889: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
890: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;