[Home] [Help]
664:
665:
666: IF g_level_procedure >= g_current_runtime_level THEN
667: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PREPAY_DIST_LINKS',
668: 'Insert into AP_Prepay_App_Dists');
669: END IF;
670:
671: --Bug 8725986: Insert statement same as of apidstln.sql version 120.5.12000000.15
672: INSERT INTO AP_Prepay_App_Dists
668: 'Insert into AP_Prepay_App_Dists');
669: END IF;
670:
671: --Bug 8725986: Insert statement same as of apidstln.sql version 120.5.12000000.15
672: INSERT INTO AP_Prepay_App_Dists
673: (PREPAY_APP_DIST_ID,
674: PREPAY_DIST_LOOKUP_CODE,
675: INVOICE_DISTRIBUTION_ID,
676: PREPAY_APP_DISTRIBUTION_ID,
683: LAST_UPDATE_DATE,
684: LAST_UPDATE_LOGIN,
685: CREATED_BY,
686: CREATION_DATE)
687: SELECT AP_Prepay_App_Dists_S.Nextval,
688: Prepay_Dist_Lookup_Code,
689: Invoice_Distribution_ID,
690: Prepay_App_Distribution_ID,
691: Accounting_Event_ID,
857: GAIN_OR_LOSS_REF ) --Bug7169843 Ends
858: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg)
859: use_nl_with_index (xte, xla_transaction_entities_n1)
860: use_nl_with_index (xle, xla_events_u2)
861: use_nl_with_index (apad, ap_prepay_app_dists_n3)
862: use_nl_with_index (aid, ap_invoice_distributions_u2)
863: use_nl_with_index (aeh, xla_ae_headers_n2)
864: use_nl_with_index (ael, xla_ae_lines_u1) */
865: 200 Application_ID,
912: XLA_Upgrade_Dates UPG,
913: XLA_Transaction_Entities_upg XTE,
914: XLA_Events XLE,
915: -- AP_Accounting_Events_All AAE,
916: AP_Prepay_App_Dists APAD,
917: AP_Invoice_Distributions_All AID,
918: XLA_AE_Headers AEH,
919: XLA_AE_Lines AEL
920: WHERE AI.rowid between p_start_rowid and p_end_rowid