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_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 252: AP_Invoice_Distributions_All AID

248: AID.Accounting_Date,
249: -- 6718967
250: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
251: FROM AP_Invoice_Lines_ALL AIL,
252: AP_Invoice_Distributions_All AID
253: WHERE AIL.Invoice_ID = p_invoice_id
254: AND AIL.Line_Type_Lookup_Code = 'PREPAY'
255: AND AIL.Invoice_ID = AID.Invoice_ID
256: AND AIL.Line_Number = AID.Invoice_Line_Number

Line 469: FROM ap_invoice_distributions_all aid,

465: l_dist_count_per_event NUMBER;
466:
467: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
468: SELECT SUM(amount), count(1)
469: FROM ap_invoice_distributions_all aid,
470: xla_events evnt,
471: xla_ae_headers xah,
472: ap_system_parameters_all asp
473: WHERE aid.accounting_event_id = p_acct_event_id

Line 783: -- FROM AP_Invoice_Distributions_ALL AID,

779: --
780: -- commenting below for bug10183934
781: --SELECT count(*)
782: -- INTO l_upg_prepay_app
783: -- FROM AP_Invoice_Distributions_ALL AID,
784: -- XLA_AE_Headers XAH
785: -- WHERE AID.accounting_event_id = XAH.Event_ID
786: -- AND XAH.Application_ID = 200
787: -- AND XAH.Event_type_Code IN ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')

Line 848: FROM AP_Invoice_Distributions_All AID

844: SUM(DECODE(aid.line_type_lookup_code, 'AWT', NVL(AID.Amount,0),0 ) )
845: INTO G_Total_Dist_amount,
846: G_Total_Inv_amount,
847: G_Total_awt_amount --Bug9106549
848: FROM AP_Invoice_Distributions_All AID
849: WHERE AID.Invoice_ID = p_invoice_id
850: AND AID.Line_Type_Lookup_Code <> 'PREPAY'
851: AND AID.Prepay_Distribution_ID IS NULL
852: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5

Line 1065: FROM AP_Invoice_Distributions_All AID,

1061: AID.Amount_Variance,
1062: AID.Base_Amount_Variance,
1063: AID.Historical_Flag, -- bug fix 6674279
1064: AID.Accounting_Event_Id -- bug fix 6674279
1065: FROM AP_Invoice_Distributions_All AID,
1066: AP_Prepay_App_Dists APAD,
1067: Financials_System_Params_All FSP
1068: WHERE AID.Invoice_ID = P_Invoice_ID
1069: AND NVL(AID.Reversal_Flag,'N') <> 'Y'

Line 1092: FROM AP_Invoice_Distributions_All AID

1088: AID.Accounting_Event_ID,
1089: AID.Prepay_Distribution_ID,
1090: AID.Prepay_Tax_Diff_Amount,
1091: AID.Parent_Reversal_ID
1092: FROM AP_Invoice_Distributions_All AID
1093: WHERE Accounting_Event_ID = P_Event_ID
1094: AND EXISTS (SELECT 'Prepay History'
1095: FROM AP_Prepay_History_All APH,
1096: AP_Invoice_Distributions_All AID1

Line 1096: AP_Invoice_Distributions_All AID1

1092: FROM AP_Invoice_Distributions_All AID
1093: WHERE Accounting_Event_ID = P_Event_ID
1094: AND EXISTS (SELECT 'Prepay History'
1095: FROM AP_Prepay_History_All APH,
1096: AP_Invoice_Distributions_All AID1
1097: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
1098: AND AID1.Invoice_Distribution_ID = AID.Prepay_Distribution_ID
1099: AND AID1.Invoice_ID = APH.Prepay_Invoice_ID
1100: AND AID1.Invoice_Line_Number = APH.Prepay_Line_Num)

Line 1111: FROM AP_Invoice_Distributions_All AID

1107: AID.Accounting_Event_ID,
1108: AID.Prepay_Distribution_ID,
1109: AID.Prepay_Tax_Diff_Amount,
1110: AID.Parent_Reversal_ID
1111: FROM AP_Invoice_Distributions_All AID
1112: WHERE Line_Type_Lookup_Code IN ( 'NONREC_TAX','REC_TAX')
1113: AND Accounting_Event_ID = P_Event_ID
1114: AND Charge_Applicable_To_Dist_ID IN
1115: (SELECT AID1.Invoice_Distribution_ID

Line 1116: FROM AP_Invoice_Distributions_All AID1

1112: WHERE Line_Type_Lookup_Code IN ( 'NONREC_TAX','REC_TAX')
1113: AND Accounting_Event_ID = P_Event_ID
1114: AND Charge_Applicable_To_Dist_ID IN
1115: (SELECT AID1.Invoice_Distribution_ID
1116: FROM AP_Invoice_Distributions_All AID1
1117: WHERE Line_Type_Lookup_Code = 'PREPAY'
1118: AND Accounting_Event_ID = P_Event_ID
1119: AND EXISTS (SELECT 'Prepay History'
1120: FROM AP_Prepay_History_All APH,

Line 1121: AP_Invoice_Distributions_All AID2

1117: WHERE Line_Type_Lookup_Code = 'PREPAY'
1118: AND Accounting_Event_ID = P_Event_ID
1119: AND EXISTS (SELECT 'Prepay History'
1120: FROM AP_Prepay_History_All APH,
1121: AP_Invoice_Distributions_All AID2
1122: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
1123: AND AID2.Invoice_Distribution_ID = AID1.Prepay_Distribution_ID
1124: AND AID2.Invoice_ID = APH.Prepay_Invoice_ID
1125: AND AID2.Invoice_Line_Number = APH.Prepay_Line_Num)));

Line 1233: FROM AP_Invoice_Distributions_All AID

1229: SELECT SUM(NVL(AID.Amount,0)),
1230: SUM(DECODE(aid.line_type_lookup_code, 'AWT', 0, NVL(AID.Amount,0) ) )
1231: INTO G_Total_Dist_amount,
1232: G_Total_Inv_amount
1233: FROM AP_Invoice_Distributions_All AID
1234: WHERE AID.Invoice_ID = l_prepay_hist_rec.invoice_id
1235: AND AID.Line_Type_Lookup_Code <> 'PREPAY'
1236: AND AID.Prepay_Distribution_ID IS NULL
1237: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5

Line 1338: FROM AP_Invoice_Distributions_All AID

1334:
1335:
1336: SELECT SUM(AID.Amount)
1337: INTO l_inv_adj_amount
1338: FROM AP_Invoice_Distributions_All AID
1339: WHERE AID.Accounting_Event_ID = l_prepay_hist_rec.invoice_adjustment_event_id;
1340:
1341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1342: l_log_msg := 'l_inv_adj_amount = ' ||l_inv_adj_amount;

Line 1359: FROM AP_Invoice_Distributions_All AID

1355: SELECT SUM(NVL(AID.Amount,0)),
1356: SUM(DECODE(aid.line_type_lookup_code, 'AWT', 0, NVL(AID.Amount,0) ) )
1357: INTO G_Total_Dist_amount,
1358: G_Total_Inv_amount
1359: FROM AP_Invoice_Distributions_All AID
1360: WHERE AID.Invoice_ID = l_inv_rec.invoice_id
1361: AND AID.Line_Type_Lookup_Code <> 'PREPAY'
1362: AND AID.Prepay_Distribution_ID IS NULL
1363: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5

Line 1444: -- joined with ap_invoice_distributions_all for the performance issue 7235352

1440: ;
1441:
1442: IF ( l_rounding_adjust_id = p_xla_event_rec.event_id ) THEN
1443:
1444: -- joined with ap_invoice_distributions_all for the performance issue 7235352
1445: SELECT /*+ leading(aid) */ SUM(DECODE(APAD.Prepay_Dist_Lookup_Code, 'PREPAY APPL', APAD.Amount,
1446: 'PREPAY APPL REC TAX', APAD.Amount,
1447: 'PREPAY APPL NONREC TAX', APAD.Amount, 0)),
1448: SUM(DECODE(APAD.Prepay_Dist_Lookup_Code, 'TAX DIFF', APAD.Amount, 0))

Line 1452: ap_invoice_distributions_all aid

1448: SUM(DECODE(APAD.Prepay_Dist_Lookup_Code, 'TAX DIFF', APAD.Amount, 0))
1449: INTO l_sum_prepaid_amount,
1450: l_sum_tax_diff_amount
1451: FROM AP_Prepay_App_Dists APAD,
1452: ap_invoice_distributions_all aid
1453: WHERE APAD.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1454: AND apad.invoice_distribution_id = aid.invoice_distribution_id
1455: AND aid.invoice_id = l_prepay_dist_rec.invoice_id;
1456:

Line 1805: FROM AP_Invoice_Distributions_All AID

1801:
1802: /* -- 8244163
1803: SELECT SUM(NVL(AID.Amount,0))
1804: INTO l_total_dist_amount
1805: FROM AP_Invoice_Distributions_All AID
1806: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1807: AND AID.Line_Type_Lookup_Code <> 'PREPAY'
1808: AND AID.Prepay_Distribution_ID IS NULL
1809: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5

Line 1889: FROM ap_invoice_distributions_all

1885: WHERE apad.prepay_dist_lookup_code = 'AWT'
1886: AND apad.awt_related_id = p_inv_dist_rec.invoice_distribution_id
1887: AND apad.invoice_distribution_id in
1888: (SELECT invoice_distribution_id
1889: FROM ap_invoice_distributions_all
1890: WHERE invoice_id = p_inv_rec.invoice_id
1891: AND line_type_lookup_code = 'AWT');
1892: */
1893: l_prorated_amount := -1 * (p_inv_dist_rec.amount - l_total_paid_amt +

Line 1933: from ap_invoice_distributions_all aid

1929: )
1930: +
1931: nvl(
1932: (select sum(amount) / l_total_dist_amount * p_prepay_dist_rec.amount
1933: from ap_invoice_distributions_all aid
1934: where aid.invoice_id=p_inv_rec.invoice_id
1935: and aid.awt_invoice_payment_id is null
1936: and aid.awt_related_id=p_inv_dist_rec.invoice_distribution_id
1937: ), 0)

Line 3048: ap_invoice_distributions_all aid

3044: AND apph.transaction_type <> 'PREPAYMENT APPLICATION ADJ' --bug9973070
3045: AND NOT EXISTS
3046: (SELECT /*+ no_unnest */ 1 --bug12337556
3047: FROM ap_prepay_app_dists apad,
3048: ap_invoice_distributions_all aid
3049: WHERE apad.prepay_history_id = apph.prepay_history_id
3050: AND apad.prepay_app_distribution_id = aid.invoice_distribution_id
3051: AND (aid.posted_flag = 'Y' OR aid.encumbered_flag = 'Y')));
3052:

Line 3063: ap_invoice_distributions_all aid

3059: AND apph.transaction_type <> 'PREPAYMENT APPLICATION ADJ' --bug9973070
3060: AND NOT EXISTS
3061: (SELECT /*+ no_unnest */ 1 --bug12337556
3062: FROM ap_prepay_app_dists apad,
3063: ap_invoice_distributions_all aid
3064: WHERE apad.prepay_history_id = apph.prepay_history_id
3065: AND apad.prepay_app_distribution_id = aid.invoice_distribution_id
3066: AND (aid.posted_flag = 'Y' OR aid.encumbered_flag = 'Y')));
3067:

Line 3421: AP_Invoice_Distributions_All AID,

3417: AP_System_Parameters_All ASP,
3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,
3421: AP_Invoice_Distributions_All AID,
3422: XLA_AE_Headers AEH,
3423: XLA_AE_Lines AEL
3424: WHERE XLE.event_id = p_accounting_event_id
3425: AND AI.Org_Id = ASP.Org_Id

Line 3523: AP_Invoice_Distributions_All AID,

3519: AP_System_Parameters_All ASP,
3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,
3523: AP_Invoice_Distributions_All AID,
3524: XLA_AE_Headers AEH,
3525: XLA_AE_Lines AEL
3526: WHERE XLE.event_id = p_accounting_event_id
3527: AND AI.Org_Id = ASP.Org_id