DBA Data[Home] [Help]

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 367: FROM MTL_SYSTEM_ITEMS msi,

363:
364: CURSOR check_shippable_item_cur(pn_order_line_id NUMBER)
365: IS
366: SELECT COUNT(1)
367: FROM MTL_SYSTEM_ITEMS msi,
368: JAI_OM_OE_RMA_LINES l
369: WHERE msi.inventory_item_id = pr_new.inventory_item_id
370: AND msi.inventory_item_id = l.inventory_item_id
371: AND l.rma_line_id = pn_order_line_id