[Home] [Help]
55: INDEX (fsp financials_system_params_u1) INDEX (lgr gl_ledgers_u2)*/
56: poh.po_header_id, poh.last_update_date,poh.vendor_id,poh.vendor_site_id,
57: fsp.set_of_books_id, fsp.org_id, fsp.inventory_organization_id,
58: lgr.chart_of_accounts_id
59: FROM po_headers_all poh,
60: financials_system_params_all fsp,
61: xla_upgrade_dates upd,
62: gl_ledgers lgr
63: WHERE poh.rowid BETWEEN p_start_rowid AND p_end_rowid
278: lgr.chart_of_accounts_id,
279: atc1.tax_recovery_rule_id,
280: atc1.tax_recovery_rate,
281: pov.vendor_type_lookup_code
282: FROM po_headers_all poh,
283: po_distributions_all pod,
284: po_line_locations_all poll,
285: po_lines_all pol,
286: ap_tax_codes_all atc,
327: atc1.tax_recovery_rate,
328: pov.vendor_type_lookup_code
329: FROM po_line_locations_all poll,
330: po_distributions_all pod,
331: po_headers_all poh,
332: po_lines_all pol,
333: ap_tax_codes_all atc,
334: ar_tax_group_codes_all atg,
335: ap_tax_codes_all atc1,
554: where other_doc_application_id = 201
555: and other_doc_entity_code = 'PURCHASE_ORDER'
556: and other_doc_event_class_code = 'PO_PA'
557: ) zxvalerr,
558: po_headers_all poh,
559: po_distributions_all pod,
560: po_line_locations_all poll,
561: po_lines_all pol,
562: ap_tax_codes_all atc,
607: and other_doc_entity_code = 'RELEASE'
608: and other_doc_event_class_code = 'RELEASE'
609: ) zxvalerr,
610: po_line_locations_all poll,
611: po_headers_all poh,
612: po_distributions_all pod,
613: po_lines_all pol,
614: ap_tax_codes_all atc,
615: ar_tax_group_codes_all atg,