eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 3392: SELECT 1 from JAI_OM_OE_RMA_LINES

3388: FROM RA_CUSTOMER_TRX_ALL
3389: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3390:
3391: CURSOR check_rma_ref IS
3392: SELECT 1 from JAI_OM_OE_RMA_LINES
3393: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
3394: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
3396: Where a.tax_id = b.tax_id

Line 4737: JAI_OM_OE_RMA_LINES l,

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
4741: /*AND l.rma_line_id = rctl.interface_line_attribute6*/ /*Commented and added below by mmurtuza for bug 16181417*/

Line 4787: JAI_OM_OE_RMA_LINES l,

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
4791: /*AND l.rma_line_id = rctl.interface_line_attribute6*/ /*Commented and added below by mmurtuza for bug 16181417*/