DBA Data[Home] [Help]

APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on OE_ORDER_LINES_ALL

Line 110: OE_ORDER_LINES_ALL OOLA, FND_CURRENCIES_VL FCV

106: --both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL
107: SELECT NVL(SUM(ARPS.AMOUNT_DUE_REMAINING),0), FCV.NAME
108: into x_invoice_balance, x_invoice_currency
109: FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,
110: OE_ORDER_LINES_ALL OOLA, FND_CURRENCIES_VL FCV
111: WHERE OOLA.HEADER_ID = p_order_header_id
112: AND RCTL.INTERFACE_LINE_ATTRIBUTE6 = to_char(OOLA.LINE_ID)
113: AND RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
114: AND RCTL.CUSTOMER_TRX_ID = ARPS.CUSTOMER_TRX_ID