DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on MTL_SYSTEM_ITEMS

Line 2188: FROM MTL_SYSTEM_ITEMS msi,

2184: */
2185: CURSOR check_shippable_item_cur(pn_inventory_item_id NUMBER,pn_order_line_id NUMBER)
2186: IS
2187: SELECT COUNT(1)
2188: FROM MTL_SYSTEM_ITEMS msi,
2189: JAI_OM_OE_RMA_LINES l
2190: WHERE msi.inventory_item_id = pn_inventory_item_id
2191: AND msi.inventory_item_id = l.inventory_item_id
2192: AND l.rma_line_id = pn_order_line_id