DBA Data[Home] [Help]

APPS.ICX_CAT_FPI_UPGRADE dependencies on PO_REQEXPRESS_LINES_ALL

Line 585: po_reqexpress_lines_all prl,

581: prl.line_type_id,
582: prl.suggested_buyer_id buyer_id,
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

Line 651: po_reqexpress_lines_all prl,

647: prl.suggested_buyer_id buyer_id,
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

Line 688: po_reqexpress_lines_all prl

684: prl.suggested_buyer_id buyer_id,
685: sub.rowid row_id
686: FROM icx_por_oracle_item_subtable sub,
687: po_reqexpress_headers_all prh,
688: po_reqexpress_lines_all prl
689: WHERE sub.rt_item_id = p_rt_item_id
690: AND sub.orc_template_id is not null
691: AND sub.orc_contract_id is null
692: AND sub.search_type = 'INTERNAL'