DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 2189: JAI_OM_OE_RMA_LINES l

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
2193: AND msi.shippable_item_flag = 'N' ;