DBA Data[Home] [Help]

APPS.OZF_ACCT_GENERATOR dependencies on OE_ORDER_LINES_ALL

Line 424: FROM oe_order_lines_all

420: COMMITMENT_ID,
421: SALESREP_ID,
422: INVENTORY_ITEM_ID,
423: ITEM_TYPE_CODE
424: FROM oe_order_lines_all
425: WHERE LINE_ID = p_line_id;
426:
427: CURSOR header_detail_csr(p_header_id in number) IS
428: SELECT HEADER_ID,

Line 439: FROM OE_ORDER_LINES_ALL

435:
436: CURSOR order_line_csr(p_line_id in number) IS
437: SELECT REFERENCE_LINE_ID,
438: LINE_CATEGORY_CODE
439: FROM OE_ORDER_LINES_ALL
440: WHERE LINE_ID = p_line_id;
441:
442: CURSOR order_header_csr(p_header_id in number) IS
443: SELECT ORDER_CATEGORY_CODE,

Line 1007: FROM OE_ORDER_LINES_ALL

1003:
1004: CURSOR item_type_csr(p_line_id in number) IS
1005: SELECT LINK_TO_LINE_ID,
1006: ITEM_TYPE_CODE
1007: FROM OE_ORDER_LINES_ALL
1008: WHERE LINE_ID = p_line_id;
1009:
1010: CURSOR cost_of_sales_acct_csr(p_line_id in number) IS
1011: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)

Line 1012: FROM OE_ORDER_LINES_ALL OL,

1008: WHERE LINE_ID = p_line_id;
1009:
1010: CURSOR cost_of_sales_acct_csr(p_line_id in number) IS
1011: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
1012: FROM OE_ORDER_LINES_ALL OL,
1013: MTL_SYSTEM_ITEMS M
1014: WHERE OL.LINE_ID = p_line_id
1015: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
1016: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;