DBA Data[Home] [Help]

APPS.JAI_GST_GENERAL_PKG dependencies on MTL_ITEM_CATEGORIES_V

Line 266: FROM mtl_item_categories_v d

262: NVL(b.start_date_active, pd_ordered_date) AND
263: NVL(b.end_date_active, SYSDATE)
264: AND EXISTS
265: (SELECT 'x'
266: FROM mtl_item_categories_v d
267: WHERE d.category_set_name = lv_category_set_name
268: AND d.inventory_item_id = pn_inventory_item_id
269: AND c.product_attr_value = TO_CHAR(d.category_id));
270:

Line 286: FROM mtl_item_categories_v d

282: TRUNC(pd_ordered_date)
283: AND NVL(primary_uom_flag, 'N') = 'Y'
284: AND EXISTS
285: (SELECT 'x'
286: FROM mtl_item_categories_v d
287: WHERE d.category_set_name = lv_category_set_name
288: AND d.inventory_item_id = pn_inventory_item_id
289: AND c.product_attr_value = TO_CHAR(d.category_id));
290:

Line 305: FROM mtl_item_categories_v d

301: AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
302: TRUNC(pd_ordered_date)
303: AND EXISTS
304: (SELECT 'x'
305: FROM mtl_item_categories_v d
306: WHERE d.category_set_name = lv_category_set_name
307: AND d.inventory_item_id = pn_inventory_item_id
308: AND c.product_attr_value = TO_CHAR(d.category_id));
309:

Line 326: FROM mtl_item_categories_v d

322: NVL(b.start_date_active, pd_ordered_date) AND
323: NVL(b.end_date_active, SYSDATE)
324: AND EXISTS
325: (SELECT 'x'
326: FROM mtl_item_categories_v d
327: WHERE d.category_set_name = lv_category_set_name
328: AND d.inventory_item_id = pn_inventory_item_id
329: AND c.product_attr_value = TO_CHAR(d.category_id));
330:

Line 346: FROM mtl_item_categories_v d

342: TRUNC(pd_ordered_date)
343: AND NVL(primary_uom_flag, 'N') = 'Y'
344: AND EXISTS
345: (SELECT 'x'
346: FROM mtl_item_categories_v d
347: WHERE d.category_set_name = lv_category_set_name
348: AND d.inventory_item_id = pn_inventory_item_id
349: AND c.product_attr_value = TO_CHAR(d.category_id));
350:

Line 365: FROM mtl_item_categories_v d

361: AND TRUNC(NVL(b.end_date_active, SYSDATE)) >=
362: TRUNC(pd_ordered_date)
363: AND EXISTS
364: (SELECT 'x'
365: FROM mtl_item_categories_v d
366: WHERE d.category_set_name = lv_category_set_name
367: AND d.inventory_item_id = pn_inventory_item_id
368: AND c.product_attr_value = TO_CHAR(d.category_id));
369: ----------------------------------------------------------------------------------------------------------