DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 4037: FROM MTL_SYSTEM_ITEMS msi,

4033: */
4034: CURSOR check_shippable_item_cur(pn_inventory_item_id NUMBER,pn_order_line_id NUMBER)
4035: IS
4036: SELECT COUNT(1)
4037: FROM MTL_SYSTEM_ITEMS msi,
4038: JAI_OM_OE_RMA_LINES l
4039: WHERE msi.inventory_item_id = pn_inventory_item_id
4040: AND msi.inventory_item_id = l.inventory_item_id
4041: AND l.rma_line_id = pn_order_line_id