71: ) poh,
72: po_distributions_all pod,
73: po_line_locations_all poll,
74: po_lines_all pol,
75: ap_tax_codes_all atc,
76: ar_tax_group_codes_all atg,
77: ap_tax_codes_all atc1,
78: po_vendors pov
79: WHERE poh.po_header_id = pod.po_header_id
73: po_line_locations_all poll,
74: po_lines_all pol,
75: ap_tax_codes_all atc,
76: ar_tax_group_codes_all atg,
77: ap_tax_codes_all atc1,
78: po_vendors pov
79: WHERE poh.po_header_id = pod.po_header_id
80: AND pol.po_header_id = poll.po_header_id
81: AND pol.po_line_id = poll.po_line_id
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,
283: ar_tax_group_codes_all atg,
284: ap_tax_codes_all atc1,
285: po_vendors pov,
286: financials_system_params_all fsp,
280: po_line_locations_all poll,
281: po_lines_all pol,
282: ap_tax_codes_all atc,
283: ar_tax_group_codes_all atg,
284: ap_tax_codes_all atc1,
285: po_vendors pov,
286: financials_system_params_all fsp,
287: gl_ledgers lgr
288: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
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,
332: po_vendors pov,
333: financials_system_params_all fsp,
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,
332: po_vendors pov,
333: financials_system_params_all fsp,
334: gl_ledgers lgr
335: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
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,
559: ar_tax_group_codes_all atg,
560: ap_tax_codes_all atc1,
561: po_vendors pov,
562: financials_system_params_all fsp,
556: po_line_locations_all poll,
557: po_lines_all pol,
558: ap_tax_codes_all atc,
559: ar_tax_group_codes_all atg,
560: ap_tax_codes_all atc1,
561: po_vendors pov,
562: financials_system_params_all fsp,
563: gl_ledgers lgr
564: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
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,
612: ap_tax_codes_all atc1,
613: po_vendors pov,
614: financials_system_params_all fsp,
608: po_distributions_all pod,
609: po_lines_all pol,
610: ap_tax_codes_all atc,
611: ar_tax_group_codes_all atg,
612: ap_tax_codes_all atc1,
613: po_vendors pov,
614: financials_system_params_all fsp,
615: gl_ledgers lgr
616: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id