DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on MTL_ITEM_CATEGORIES

Line 553: select category_id,category_set_id from mtl_item_categories

549: )
550: IS
551: CURSOR C_GET_CATEGORY_FROM_ITEM(l_organization_id NUMBER,
552: l_item_id NUMBER) IS
553: select category_id,category_set_id from mtl_item_categories
554: where category_set_id=
555: (select category_set_id
556: from mtl_default_category_sets
557: where functional_area_id=G_FUNCTIONAL_AREA)

Line 3551: MTL_ITEM_CATEGORIES MIC,

3547: c_inventory_item_id number,
3548: c_organization_id number) IS
3549: select 'x'
3550: FROM
3551: MTL_ITEM_CATEGORIES MIC,
3552: MTL_SYSTEM_ITEMS_VL ITEMS,
3553: ENI_PROD_DEN_HRCHY_PARENTS_V P
3554: WHERE
3555: MIC.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND