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.PV_ENRL_REQUEST_ORDER_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 7: -- both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL

3:
4: --Comments
5: --kvattiku: Aug 05, 05 Commented out for R12 in Get_payment_type. Directly retrieve from pv_lookups.
6: -- Added prefix ARPS to the AMOUNT_DUE_REMAINING column as it exists in
7: -- both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL
8:
9: -- Global constant holding the package name
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENRL_REQUEST_ORDER_PUB';

Line 106: --both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL

102:
103: IF (p_order_header_id IS NOT NULL ) THEN
104:
105: --kvattiku: Aug 05, 05 Added prefix ARPS to the AMOUNT_DUE_REMAINING column as it exists in
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

Line 109: FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,

105: --kvattiku: Aug 05, 05 Added prefix ARPS to the AMOUNT_DUE_REMAINING column as it exists in
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'

Line 136: --both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL

132: ,x_invoice_number OUT NOCOPY VARCHAR2
133: ) IS
134: BEGIN
135: --kvattiku: Aug 05, 05 Added prefix ARPS to the AMOUNT_DUE_REMAINING column as it exists in
136: --both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL
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,

Line 140: FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,

136: --both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL
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