[Home] [Help]
989: END IF;
990:
991: IF g_level_procedure >= g_current_runtime_level THEN
992: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PAYMENT_DIST_LINKS',
993: 'Insert into ap_payment_hist_dists');
994: END IF;
995:
996: --Bug 8725986: Insert statement same as of appdstln.sql version 120.4.12000000.16
997: INSERT INTO ap_payment_hist_dists
993: 'Insert into ap_payment_hist_dists');
994: END IF;
995:
996: --Bug 8725986: Insert statement same as of appdstln.sql version 120.4.12000000.16
997: INSERT INTO ap_payment_hist_dists
998: (PAYMENT_HIST_DIST_ID,
999: ACCOUNTING_EVENT_ID,
1000: PAY_DIST_LOOKUP_CODE,
1001: INVOICE_DISTRIBUTION_ID,
1013: LAST_UPDATED_BY,
1014: LAST_UPDATE_LOGIN,
1015: PA_ADDITION_FLAG)
1016: /* bug#6662100 the query is modified to improve performance */
1017: SELECT AP_Payment_Hist_Dists_S.Nextval,
1018: Accounting_Event_ID,
1019: Pay_Dist_Lookup_Code,
1020: Invoice_Distribution_ID,
1021: Decode(Rank_Num, Dist_Count, Entered_Amount + Delta_Entered, Entered_Amount) Amount,
1346: use_nl_with_index (aeh, xla_ae_headers_n2)
1347: use_nl_with_index (ael, xla_ae_lines_u1)
1348: use_nl_with_index (aph, ap_payment_history_n2)
1349: use_nl_with_index (aid, ap_invoice_distributions_n26)
1350: use_nl_with_index (aphd, ap_payment_hist_dists_n2)
1351: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
1352: 200 Application_ID,
1353: AEH.Event_ID Accounting_Event_ID,
1354: AEH.AE_Header_ID AE_Header_ID,
1579: AP_Payment_History_All APH,
1580: XLA_AE_Headers AEH,
1581: XLA_AE_Lines AEL,
1582: AP_Invoice_Distributions_All AID,
1583: AP_Payment_Hist_Dists APHD,
1584: XLA_Events XTE_INV, --Bug7169843
1585: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes
1586: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid
1587: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1624: use_nl_with_index (xle, xla_events_u2)
1625: use_nl_with_index (aeh, xla_ae_headers_n2)
1626: use_nl_with_index (ael, xla_ae_lines_u1)
1627: use_nl_with_index (aph, ap_payment_history_n2)
1628: use_nl_with_index (aphd, ap_payment_hist_dists_n1)
1629: use_nl_with_index (aid, ap_invoice_distributions_u2)
1630: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
1631: 200 Application_ID,
1632: AEH.Event_ID Accounting_Event_ID,
1853: XLA_Events XLE,
1854: AP_Payment_History_All APH,
1855: XLA_AE_Headers AEH,
1856: XLA_AE_Lines AEL,
1857: AP_Payment_Hist_Dists APHD,
1858: AP_Invoice_Distributions_All AID,
1859: XLA_Events XTE_INV, --Bug7169843
1860: ZX_Rec_Nrec_Dist ZRD -- 7360647 changes
1861: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid