DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PO_HEADERS_TRX_V

Line 1575: FROM po_headers_trx_v poh, po_lines_trx_v pol, po_line_locations_trx_v poll--CLM Changes, using CLM views instead of base tables

1571: BEGIN
1572: SELECT poh.po_header_id, poh.segment1, pol.po_line_id, pol.line_num
1573: INTO l_material_rec.document_id, l_material_rec.document_number
1574: , l_material_rec.document_line_id, l_material_rec.document_line_num
1575: FROM po_headers_trx_v poh, po_lines_trx_v pol, po_line_locations_trx_v poll--CLM Changes, using CLM views instead of base tables
1576: WHERE poll.line_location_id = l_material_rec.reference_id
1577: AND poh.po_header_id = poll.po_header_id
1578: AND pol.po_line_id = poll.po_line_id;
1579: EXCEPTION