DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 216: FROM mtl_item_categories mtl,

212:
213: CURSOR items_csr (p_item_type VARCHAR2,
214: p_item_id NUMBER) IS
215: SELECT inventory_item_id
216: FROM mtl_item_categories mtl,
217: eni_prod_denorm_hrchy_v eni
218: WHERE mtl.category_set_id = eni.category_set_id
219: AND mtl.category_id = eni.child_id
220: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

Line 577: FROM mtl_item_categories mtl,

573:
574: CURSOR items_csr (p_item_type VARCHAR2,
575: p_item_id NUMBER) IS
576: SELECT inventory_item_id
577: FROM mtl_item_categories mtl,
578: eni_prod_denorm_hrchy_v eni
579: WHERE mtl.category_set_id = eni.category_set_id
580: AND mtl.category_id = eni.child_id
581: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

Line 1814: FROM mtl_item_categories mtl,

1810:
1811: CURSOR items_csr (p_item_type VARCHAR2,
1812: p_item_id NUMBER) IS
1813: SELECT inventory_item_id
1814: FROM mtl_item_categories mtl,
1815: eni_prod_denorm_hrchy_v eni
1816: WHERE mtl.category_set_id = eni.category_set_id
1817: AND mtl.category_id = eni.child_id
1818: AND mtl.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')