DBA Data[Home] [Help]

APPS.ICX_CAT_FPI_UPGRADE dependencies on PO_VENDORS

Line 588: po_vendors pv

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
592: AND sub.orc_template_id = prl.express_name

Line 623: po_vendors pv

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
627: AND sub.orc_contract_line_id = pl.po_line_id

Line 652: po_vendors pv

648: sub.rowid row_id
649: FROM icx_por_oracle_item_subtable sub,
650: po_reqexpress_headers_all prh,
651: po_reqexpress_lines_all prl,
652: po_vendors pv
653: WHERE sub.rt_item_id = p_rt_item_id
654: AND sub.orc_template_id is not null
655: AND sub.orc_contract_id is null
656: AND prh.express_name = sub.orc_template_id