583: sub.rowid row_id
584: FROM icx_por_oracle_item_subtable sub,
585: po_reqexpress_lines_all prl,
586: po_headers_all ph,
587: po_lines_all pl,
588: po_vendors pv
589: WHERE sub.rt_item_id = p_rt_item_id
590: AND sub.orc_template_id is not null
591: AND sub.orc_contract_id is not null
618: ph.agent_id buyer_id,
619: sub.rowid row_id
620: FROM icx_por_oracle_item_subtable sub,
621: po_headers_all ph,
622: po_lines_all pl,
623: po_vendors pv
624: WHERE sub.rt_item_id = p_rt_item_id
625: AND sub.orc_contract_id is not null
626: AND sub.orc_contract_id = ph.po_header_id