DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on MTL_SYSTEM_ITEMS

Line 298: FROM MTL_SYSTEM_ITEMS msi, JAI_OM_OE_RMA_LINES l

294: 'R_RMA_FOR_OTA_CREDIT');
295:
296: CURSOR check_shippable_item_cur(pn_order_line_id NUMBER) IS
297: SELECT COUNT(1)
298: FROM MTL_SYSTEM_ITEMS msi, JAI_OM_OE_RMA_LINES l
299: WHERE msi.inventory_item_id = pr_new.inventory_item_id
300: AND msi.inventory_item_id = l.inventory_item_id
301: AND l.rma_line_id = pn_order_line_id
302: AND msi.shippable_item_flag = 'N';