DBA Data[Home] [Help]

APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on FND_CURRENCIES_VL

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

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'