DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 4389: financials_system_params_all fsp,

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
4393: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'

Line 5074: financials_system_params_all fsp,

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
5078: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid

Line 5781: financials_system_params_all fsp,

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
5785: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid

Line 6275: financials_system_params_all fsp,

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
6279: AND NVL(poh.closed_code, 'X') <> 'FINALLY CLOSED'