APPS.JAI_GENERAL_PKG dependencies on MTL_ITEM_CATEGORIES_V

Line 1017: mtl_item_categories_v d

1013: AND NVL( b.end_date_active, SYSDATE)
1014: AND EXISTS ( SELECT
1015: 'x'
1016: FROM
1017: mtl_item_categories_v d
1018: WHERE d.category_set_name = lv_category_set_name
1019: AND d.inventory_item_id = pn_inventory_item_id
1020: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1021: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 1053: mtl_item_categories_v d

1049: NVL(qlhb.active_flag,'N') = 'Y' /*Added for bug#16288090*/
1050: AND EXISTS ( SELECT
1051: 'x'
1052: FROM
1053: mtl_item_categories_v d
1054: WHERE d.category_set_name = lv_category_set_name
1055: AND d.inventory_item_id = pn_inventory_item_id
1056: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1057: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 1088: mtl_item_categories_v d

1084: AND TRUNC(NVL(b.end_date_active,SYSDATE)) >= TRUNC(pd_ordered_date)
1085: AND EXISTS ( SELECT
1086: 'x'
1087: FROM
1088: mtl_item_categories_v d
1089: WHERE d.category_set_name = lv_category_set_name
1090: AND d.inventory_item_id = pn_inventory_item_id
1091: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1092: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 1127: mtl_item_categories_v d

1123: AND NVL( b.end_date_active, SYSDATE)
1124: AND EXISTS ( SELECT
1125: 'x'
1126: FROM
1127: mtl_item_categories_v d
1128: WHERE d.category_set_name = lv_category_set_name
1129: AND d.inventory_item_id = pn_inventory_item_id
1130: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1131: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 1163: mtl_item_categories_v d

1159: AND NVL(primary_uom_flag,'N') ='Y'
1160: AND EXISTS ( SELECT
1161: 'x'
1162: FROM
1163: mtl_item_categories_v d
1164: WHERE d.category_set_name = lv_category_set_name
1165: AND d.inventory_item_id = pn_inventory_item_id
1166: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1167: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 1198: mtl_item_categories_v d

1194: AND TRUNC(NVL(b.end_date_active,SYSDATE)) >= TRUNC(pd_ordered_date)
1195: AND EXISTS ( SELECT
1196: 'x'
1197: FROM
1198: mtl_item_categories_v d
1199: WHERE d.category_set_name = lv_category_set_name
1200: AND d.inventory_item_id = pn_inventory_item_id
1201: AND c.product_attr_value = decode(c.product_attr_value,'ALL',
1202: c.product_attr_value,TO_CHAR(d.category_id)) --Modified by Junjian on 15-Oct-2012 for bug#14736812