[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
274: lgr.chart_of_accounts_id,
275: atc1.tax_recovery_rule_id,
276: atc1.tax_recovery_rate,
277: pov.vendor_type_lookup_code
278: FROM po_headers_all poh,
279: po_distributions_all pod,
280: po_line_locations_all poll,
281: po_lines_all pol,
282: ap_tax_codes_all atc,
323: atc1.tax_recovery_rate,
324: pov.vendor_type_lookup_code
325: FROM po_line_locations_all poll,
326: po_distributions_all pod,
327: po_headers_all poh,
328: po_lines_all pol,
329: ap_tax_codes_all atc,
330: ar_tax_group_codes_all atg,
331: ap_tax_codes_all atc1,
550: where other_doc_application_id = 201
551: and other_doc_entity_code = 'PURCHASE_ORDER'
552: and other_doc_event_class_code = 'PO_PA'
553: ) zxvalerr,
554: po_headers_all poh,
555: po_distributions_all pod,
556: po_line_locations_all poll,
557: po_lines_all pol,
558: ap_tax_codes_all atc,
603: and other_doc_entity_code = 'RELEASE'
604: and other_doc_event_class_code = 'RELEASE'
605: ) zxvalerr,
606: po_line_locations_all poll,
607: po_headers_all poh,
608: po_distributions_all pod,
609: po_lines_all pol,
610: ap_tax_codes_all atc,
611: ar_tax_group_codes_all atg,