DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on MTL_SYSTEM_ITEMS

Line 4736: FROM MTL_SYSTEM_ITEMS msi,

4732: 'R_RMA_FOR_CREDIT_WO_SHIPMENT', 'R_RMA_FOR_OTA_CREDIT')
4733: AND rctl.customer_trx_id = pn_customer_trx_id
4734: UNION
4735: SELECT rctl.customer_trx_line_id
4736: FROM MTL_SYSTEM_ITEMS msi,
4737: JAI_OM_OE_RMA_LINES l,
4738: ra_customer_trx_lines_all rctl
4739: WHERE msi.inventory_item_id = rctl.inventory_item_id
4740: AND msi.inventory_item_id = l.inventory_item_id

Line 4786: FROM MTL_SYSTEM_ITEMS msi,

4782: 'R_RMA_FOR_CREDIT_WO_SHIPMENT', 'R_RMA_FOR_OTA_CREDIT')
4783: AND rctl.customer_trx_id = pn_customer_trx_id
4784: UNION
4785: SELECT rctl.customer_trx_line_id
4786: FROM MTL_SYSTEM_ITEMS msi,
4787: JAI_OM_OE_RMA_LINES l,
4788: ra_customer_trx_lines_all rctl
4789: WHERE msi.inventory_item_id = rctl.inventory_item_id
4790: AND msi.inventory_item_id = l.inventory_item_id