DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 2481: SELECT 1 from JAI_OM_OE_RMA_LINES

2477: FROM RA_CUSTOMER_TRX_ALL
2478: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2479:
2480: CURSOR check_rma_ref IS
2481: SELECT 1 from JAI_OM_OE_RMA_LINES
2482: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
2483: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
2484: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
2485: Where a.tax_id = b.tax_id