APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INV_DISTS_SOURCE

Line 477: AP_Inv_Dists_Source AID1,

473: XLA_AE_Headers AEH,
474: XLA_AE_Lines AEL,
475: GL_Ledgers GL, /* bug8370714, bug 13040251 */
476: FND_Currencies FC, /* bug#6660487 changed the position for FC */
477: AP_Inv_Dists_Source AID1,
478: AP_Invoice_Distributions_All AID,
479: ZX_Rec_Nrec_Dist ZRD -- 7289100 changes
480: WHERE AI.rowid between p_start_rowid and p_end_rowid
481: AND AI.Set_Of_Books_ID = UPG.Ledger_ID

Line 777: AP_Inv_Dists_Source AID1,

773: XLA_Events XLE,
774: -- AP_Accounting_Events_All AAE,
775: AP_Prepay_History_All APH,
776: AP_Invoice_Distributions_All AID,
777: AP_Inv_Dists_Source AID1,
778: XLA_AE_Headers AEH,
779: XLA_AE_Lines AEL,
780: AP_Invoice_Distributions_All AIDP
781: WHERE AI.rowid between p_start_rowid and p_end_rowid

Line 1259: AP_Inv_Dists_Source AID1

1255: AND nvl(AID_B.line_type_lookup_code, 1) <> 'AWT'
1256: /* AWT changes end */
1257: AND AID_b.prepay_distribution_id IS NULL --7514374 excluding prepay distributions
1258: ) v2,
1259: AP_Inv_Dists_Source AID1
1260: -- optimization, since 50% of old_dist id's point to themselves
1261: WHERE AID1.Invoice_Distribution_ID(+) =
1262: DECODE(v2.Old_Distribution_ID,v2.invoice_distribution_id,TO_NUMBER(null),v2.Old_Distribution_ID)
1263: AND AID1.prepay_distribution_id IS NULL --7514374 excluding prepay distributions