DBA Data[Home] [Help]

APPS.OZF_ACCT_GENERATOR dependencies on MTL_SYSTEM_ITEMS

Line 887: MTL_SYSTEM_ITEMS M

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

Line 895: FROM MTL_SYSTEM_ITEMS

891:
892: CURSOR cogs_acct_csr( p_inventory_item_id in number
893: ,p_organization_id in number) IS
894: SELECT NVL(COST_OF_SALES_ACCOUNT,0)
895: FROM MTL_SYSTEM_ITEMS
896: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
897: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
898:
899: BEGIN