[Home] [Help]
52: X_retcode out NOCOPY varchar2,
53: X_batch_size in number,
54: X_Num_Workers in number,
55: p_application_id in fnd_application.application_id%type,
56: p_ledger_id in xla_upgrade_dates.ledger_id%type,
57: p_period_name in varchar2)
58: IS
59: l_update_name varchar2(30);
60:
2185: 'LOCATION', NULL,
2186: custtrxl.vat_tax_id) ACCOUNT_SOURCE_TAX_RATE_ID,
2187: custtrxl.autotax AUTOTAX
2188: FROM RA_CUSTOMER_TRX_ALL custtrx,
2189: XLA_UPGRADE_DATES upd,
2190: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2191: RA_CUST_TRX_TYPES_ALL types,
2192: FND_CURRENCIES fndcurr,
2193: FND_DOCUMENT_SEQUENCES fds,
3001: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3002: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3003: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3004: FROM ap_invoices_all inv,
3005: xla_upgrade_dates upd,
3006: fnd_currencies fnd_curr,
3007: fnd_document_sequences fds,
3008: ap_invoice_lines_all lines,
3009: po_line_locations_all poll,
3894: AND tax_class = 'INPUT') RECOVERY_RATE_ID
3895: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3896: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3897: FROM ap_invoices_all inv,
3898: xla_upgrade_dates upd,
3899: fnd_currencies fnd_curr,
3900: ap_inv_dists_target ap_dists,
3901: ap_inv_dists_target ap_dists1,
3902: ap_invoice_lines_all lines1,
4386: fsp.set_of_books_id,
4387: aps.base_currency_code
4388: FROM po_headers_all poh,
4389: financials_system_params_all fsp,
4390: xla_upgrade_dates upd,
4391: ap_system_parameters_all aps
4392: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
4393: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
4394: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5071: poh.* , fsp.org_id fsp_org_id, fsp.set_of_books_id,
5072: aps.base_currency_code, oi.org_information2
5073: FROM po_headers_all poh,
5074: financials_system_params_all fsp,
5075: xla_upgrade_dates upd,
5076: ap_system_parameters_all aps,
5077: hr_organization_information oi
5078: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5079: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
5778: poh.* , fsp.org_id fsp_org_id, fsp.set_of_books_id,
5779: aps.base_currency_code, oi.org_information2
5780: FROM po_headers_all poh,
5781: financials_system_params_all fsp,
5782: xla_upgrade_dates upd,
5783: ap_system_parameters_all aps,
5784: hr_organization_information oi
5785: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
5786: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
6272: NVL2(poll.po_release_id, 'RELEASE', 'PO_PA') event_class_code,
6273: NVL(poll.po_release_id, poh.po_header_id) trx_id
6274: FROM po_headers_all poh,
6275: financials_system_params_all fsp,
6276: xla_upgrade_dates upd,
6277: po_line_locations_all poll
6278: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
6279: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'
6280: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)