DBA Data[Home] [Help]

APPS.ICX_CAT_FPI_UPGRADE dependencies on PO_LINES_ALL

Line 587: po_lines_all pl,

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

Line 622: po_lines_all pl,

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