4397: AND NVL(aps.org_id, -99) = NVL(fsp.org_id, -99)
4398: AND (trunc(poh.last_update_date) between upd.start_date and upd.end_date)
4399: ) poh,
4400: fnd_currencies fc,
4401: hr_organization_information oi,
4402: po_lines_all pol,
4403: po_line_locations_all poll,
4404: zx_party_tax_profile ptp,
4405: hr_locations_all hr
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'
5080: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5081: AND upd.ledger_id = fsp.set_of_books_id
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'
5787: AND NVL(poh.org_id,-99) = NVL(fsp.org_id,-99)
5788: AND upd.ledger_id = fsp.set_of_books_id