DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on PO_HEADERS_ALL

Line 342: l_table_name :='PO_HEADERS_ALL';

338: l_table_name :='RA_CUSTOMER_TRX_ALL';
339: ELSIF p_application_id = 200 then
340: l_table_name :='AP_INVOICES_ALL';
341: ELSIF p_application_id = 201 then
342: l_table_name :='PO_HEADERS_ALL';
343: END IF;
344:
345: ad_parallel_updates_pkg.initialize_rowid_range(
346: ad_parallel_updates_pkg.ROWID_RANGE,

Line 4388: FROM po_headers_all poh,

4384: swap_join_inputs(aps) */
4385: poh.*,
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

Line 5073: FROM po_headers_all poh,

5069: swap_join_inputs(fsp) swap_join_inputs(upd)
5070: swap_join_inputs(aps) swap_join_inputs(oi)*/
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

Line 5780: FROM po_headers_all poh,

5776: swap_join_inputs(fsp) swap_join_inputs(upd)
5777: swap_join_inputs(aps) swap_join_inputs(oi)*/
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

Line 6274: FROM po_headers_all poh,

6270: poll.po_release_id,
6271: NVL2(poll.po_release_id, 'RELEASE', 'PURCHASE_ORDER') entity_code,
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