DBA Data[Home] [Help]

APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 141: FND_CURRENCIES_VL FCV, RA_CUSTOMER_TRX_ALL RCT

137: IF (p_order_line_id IS NOT NULL ) THEN
138: SELECT NVL(SUM(ARPS.AMOUNT_DUE_REMAINING),0), FCV.name, RCT.TRX_NUMBER
139: into x_invoice_balance, x_invoice_currency, x_invoice_number
140: FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,
141: FND_CURRENCIES_VL FCV, RA_CUSTOMER_TRX_ALL RCT
142: WHERE RCTL.INTERFACE_LINE_ATTRIBUTE6 = p_order_line_id
143: AND RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
144: AND RCTL.CUSTOMER_TRX_ID = ARPS.CUSTOMER_TRX_ID
145: AND ARPS.CLASS = 'INV'