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.AP_ACCOUNTING_PAY_PKG dependencies on DUAL

Line 772: select p_invoice_distribution_id from dual

768: l_bank_curr_sum
769: FROM AP_Payment_Hist_Dists APHD,
770: AP_Payment_History_All APH
771: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
772: select p_invoice_distribution_id from dual
773: union
774: -- awt distributions which are applied on the p_invoice_distribution_id
775: select distinct aid_awt.invoice_distribution_id
776: from ap_invoice_distributions_all aid_awt,

Line 817: select p_invoice_distribution_id from dual

813: l_bank_curr_sum
814: FROM AP_Payment_Hist_Dists APHD,
815: AP_Payment_History_All APH
816: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
817: select p_invoice_distribution_id from dual
818: union
819: -- awt distributions which are applied on p_invoice_distribution_id
820: select distinct aid_awt.invoice_distribution_id
821: from ap_invoice_distributions_all aid_awt,

Line 861: select p_invoice_distribution_id from dual

857: l_bank_curr_sum
858: FROM AP_Payment_Hist_Dists APHD,
859: AP_Payment_History_All APH
860: WHERE APHD.Invoice_Distribution_ID in ( /*bug 8882706*/
861: select p_invoice_distribution_id from dual
862: union
863: -- awt distributions which are applied on p_invoice_distribution_id
864: select distinct aid_awt.invoice_distribution_id
865: from ap_invoice_distributions_all aid_awt,

Line 952: FROM dual

948: FROM AP_Payment_Hist_Dists APHD
949: , AP_Payment_History_All APH
950: WHERE APHD.Invoice_Distribution_ID IN
951: (SELECT p_invoice_distribution_id
952: FROM dual
953: UNION
954: SELECT DISTINCT aid_awt.invoice_distribution_id
955: FROM ap_invoice_distributions_all aid_awt
956: , ap_invoice_distributions_all aid_item

Line 990: FROM dual

986: FROM AP_Payment_Hist_Dists APHD
987: , AP_Payment_History_All APH
988: WHERE APHD.Invoice_Distribution_ID IN
989: (SELECT p_invoice_distribution_id
990: FROM dual
991: UNION
992: SELECT DISTINCT aid_awt.invoice_distribution_id
993: FROM ap_invoice_distributions_all aid_awt
994: , ap_invoice_distributions_all aid_item

Line 1028: FROM dual

1024: FROM AP_Payment_Hist_Dists APHD
1025: , AP_Payment_History_All APH
1026: WHERE APHD.Invoice_Distribution_ID IN
1027: (SELECT p_invoice_distribution_id
1028: FROM dual
1029: UNION
1030: SELECT DISTINCT aid_awt.invoice_distribution_id
1031: FROM ap_invoice_distributions_all aid_awt
1032: , ap_invoice_distributions_all aid_item

Line 1100: select p_invoice_distribution_id from dual

1096: INTO l_prepay_sum
1097: FROM AP_Prepay_App_Dists APAD,
1098: AP_Invoice_Distributions_All AID
1099: WHERE APAD.Invoice_Distribution_ID in ( /*bug 8882706*/
1100: select p_invoice_distribution_id from dual
1101: union
1102: /* awt distributions which are applied on the p_invoice_distribution_id*/
1103: select distinct aid_awt.invoice_distribution_id
1104: from ap_invoice_distributions_all aid_awt,

Line 1152: ( SELECT p_invoice_distribution_id FROM dual

1148: , P_Paid_Base_Sum
1149: , P_Clr_Base_Curr_Sum
1150: FROM AP_Prepay_App_Dists APAD
1151: WHERE APAD.Invoice_Distribution_ID IN
1152: ( SELECT p_invoice_distribution_id FROM dual
1153: UNION
1154: SELECT DISTINCT aid_awt.invoice_distribution_id
1155: FROM ap_invoice_distributions_all aid_awt
1156: , ap_invoice_distributions_all aid_item

Line 1814: FROM DUAL

1810: END IF;
1811:
1812: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
1813: INTO l_unacctg_events_exist
1814: FROM DUAL
1815: WHERE EXISTS(
1816: SELECT 'unreversed, unaccounted payment not selected for accounting'
1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip