DBA Data[Home] [Help]

APPS.OZF_ACCT_GENERATOR dependencies on MTL_SYSTEM_ITEMS

Line 1013: MTL_SYSTEM_ITEMS M

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;
1017:

Line 1021: FROM MTL_SYSTEM_ITEMS

1017:
1018: CURSOR cogs_acct_csr( p_inventory_item_id in number
1019: ,p_organization_id in number) IS
1020: SELECT NVL(COST_OF_SALES_ACCOUNT,0)
1021: FROM MTL_SYSTEM_ITEMS
1022: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1023: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1024:
1025: BEGIN