DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on MTL_ITEM_CATEGORIES_V

Line 574: mtl_item_categories_v d

570: AND NVL( b.end_date_active, SYSDATE)
571: AND EXISTS ( SELECT
572: 'x'
573: FROM
574: mtl_item_categories_v d
575: WHERE d.category_set_name = lv_category_set_name
576: AND d.inventory_item_id = pn_inventory_item_id
577: AND c.product_attr_value = TO_CHAR(d.category_id)
578: );

Line 1026: mtl_item_categories_v d

1022: AND NVL( end_date_active, SYSDATE +1 )>= SYSDATE
1023: AND EXISTS ( SELECT
1024: 'x'
1025: FROM
1026: mtl_item_categories_v d
1027: WHERE d.category_set_name = lv_category_set_name
1028: AND d.inventory_item_id = pn_inventory_item_id
1029: AND c.product_attr_value = TO_CHAR(d.category_id)
1030: );