[Home] [Help]
245: /* bug#7289100 added hit for zrd */
246: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
247: no_expand use_hash(FC,upg)
248: use_nl_with_index (xte, xla_transaction_entities_n1)
249: use_nl_with_index (xle, xla_events_u2)
250: use_nl_with_index (aeh, xla_ae_headers_n2)
251: use_nl_with_index (ael, xla_ae_lines_u1)
252: use_nl_with_index (aid, ap_invoice_distributions_n27)
253: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
275: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
276: FROM AP_Invoices_All AI,
277: XLA_Upgrade_Dates UPG,
278: XLA_Transaction_Entities_upg XTE,
279: XLA_Events XLE,
280: -- AP_Accounting_Events_All AAE,
281: XLA_AE_Headers AEH,
282: XLA_AE_Lines AEL,
283: GL_Ledgers GL, /* bug8370714, bug 13040251 */
331: UNION ALL /* bug#7289100 added hit for zrd */
332: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
333: no_expand use_hash(FC,upg)
334: use_nl_with_index (xte, xla_transaction_entities_n1)
335: use_nl_with_index (xle, xla_events_u2)
336: use_nl_with_index (aeh, xla_ae_headers_n2)
337: use_nl_with_index (ael, xla_ae_lines_u1)
338: use_nl_with_index (aid, ap_invoice_distributions_n26)
339: use_nl_with_index (zrd,ZX_REC_NREC_DIST_U1) */
361: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
362: FROM AP_Invoices_All AI,
363: XLA_Upgrade_Dates UPG,
364: XLA_Transaction_Entities_upg XTE,
365: XLA_Events XLE,
366: -- AP_Accounting_Events_All AAE,
367: XLA_AE_Headers AEH,
368: XLA_AE_Lines AEL,
369: GL_Ledgers GL, /* bug8370714, bug 13040251 */
419: /* bug#6914954 modified the hint aid1 */
420: /* bug#7289100 added hit for zrd */
421: SELECT /*+ ordered rowid(ai) swap_join_inputs (upg) swap_join_inputs(FC)
422: use_nl_with_index (xte, xla_transaction_entities_n1)
423: use_nl_with_index (xle, xla_events_u2)
424: use_nl_with_index (aeh, xla_ae_headers_n2)
425: use_nl_with_index (ael, xla_ae_lines_u1)
426: use_nl_with_index (aid1, ap_invoice_dists_arch_u2)
427: use_nl_with_index (aid, ap_invoice_distributions_n26)
467: MERGE_DUPLICATE_CODE -- changed by abhsaxen for bug 9073033
468: FROM AP_Invoices_All AI,
469: XLA_Upgrade_Dates UPG,
470: XLA_Transaction_Entities_upg XTE,
471: XLA_Events XLE,
472: -- AP_Accounting_Events_All AAE,
473: XLA_AE_Headers AEH,
474: XLA_AE_Lines AEL,
475: GL_Ledgers GL, /* bug8370714, bug 13040251 */
731: /* bug#6914954 modified the hint aid1 */
732: SELECT /*+ ordered use_hash (asp) rowid(ai)
733: swap_join_inputs (asp) swap_join_inputs (upg) swap_join_inputs (fc)
734: use_nl_with_index (xte, xla_transaction_entities_n1)
735: use_nl_with_index (xle, xla_events_u2)
736: use_nl_with_index (aph, ap_prepay_history_n1)
737: use_nl_with_index (aid, ap_invoice_distributions_n27)
738: use_nl_with_index (aid1, ap_invoice_dists_arch_u2)
739: use_nl_with_index (aeh, xla_ae_headers_n2)
769: XLA_Upgrade_Dates UPG,
770: AP_System_Parameters_All ASP,
771: FND_Currencies FC,/* bug#6660487 changed the order of FC */
772: XLA_Transaction_Entities_upg XTE,
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,
856: APPLIED_TO_DIST_ID_NUM_1,
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) */
910: '-2222' GAIN_OR_LOSS_REF --Bug7169843 ends
911: FROM AP_Invoices_All AI,
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,
1136: from
1137: (SELECT /*+ ordered use_hash(asp, upg) rowid(ac) no_merge
1138: swap_join_inputs (upg) swap_join_inputs (asp) swap_join_inputs(fc)
1139: use_nl_with_index (xte, xla_transaction_entities_n1)
1140: use_nl_with_index (xle, xla_events_u2)
1141: use_nl_with_index (aeh, xla_ae_headers_n2)
1142: use_nl_with_index (ael, xla_ae_lines_u1)
1143: use_nl_with_index (aip, ap_invoice_payments_n2)
1144: use_nl_with_index (aph, ap_payment_history_n2)
1178: AP_System_Parameters_All ASP,
1179: XLA_Upgrade_Dates UPG,
1180: FND_Currencies FC,
1181: XLA_Transaction_Entities_Upg XTE,
1182: XLA_Events XLE,
1183: AP_Invoice_Payments_All AIP,
1184: AP_Invoices_All AI,
1185: AP_Payment_History_All APH,
1186: XLA_AE_Headers AEH,
1341: ( /* bug#7360647 added hit for zrd */
1342: SELECT /*+ ordered use_hash(asp, upg) rowid(ac)
1343: swap_join_inputs (upg) swap_join_inputs (asp)
1344: use_nl_with_index (xte, xla_transaction_entities_n1)
1345: use_nl_with_index (xle, xla_events_u2)
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)
1574: FROM AP_Checks_All AC,
1575: AP_System_Parameters_All ASP,
1576: XLA_Upgrade_Dates UPG,
1577: XLA_Transaction_Entities_Upg XTE,
1578: XLA_Events XLE,
1579: AP_Payment_History_All APH,
1580: XLA_AE_Headers AEH,
1581: XLA_AE_Lines AEL,
1582: AP_Invoice_Distributions_All AID,
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
1588: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
1620: UNION ALL /* bug#7360647 added hit for zrd */
1621: SELECT /*+ ordered use_hash(asp, upg) rowid(ac)
1622: swap_join_inputs (upg) swap_join_inputs (asp)
1623: use_nl_with_index (xte, xla_transaction_entities_n1)
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)
1849: FROM AP_Checks_All AC,
1850: AP_System_Parameters_All ASP,
1851: XLA_Upgrade_Dates UPG,
1852: XLA_Transaction_Entities_Upg XTE,
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,
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
1862: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1863: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
2104: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
2105: AND ASP.Future_Dated_Pmt_Liab_Relief = 'MATURITY'
2106: AND NOT EXISTS (SELECT 'Payment Maturity'
2107: FROM AP_Payment_History_All APH,
2108: XLA_Events XLE,
2109: XLA_AE_Headers XEH1
2110: WHERE APH.Accounting_Event_ID = XLE.Event_ID
2111: AND XLE.Event_ID = XEH1.Event_ID
2112: AND APH.Check_ID = AC.Check_ID