APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_ORACLE_ITEM_SUBTABLE

Line 584: FROM icx_por_oracle_item_subtable sub,

580: prl.item_revision,
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

Line 620: FROM icx_por_oracle_item_subtable sub,

616: pl.item_revision,
617: pl.line_type_id,
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

Line 649: FROM icx_por_oracle_item_subtable sub,

645: prl.item_revision,
646: prl.line_type_id,
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

Line 686: FROM icx_por_oracle_item_subtable sub,

682: prl.item_revision,
683: prl.line_type_id,
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

Line 752: FROM icx_por_oracle_item_subtable sub,

748: TO_CHAR(NULL) item_revision,
749: TO_NUMBER(NULL) line_type_id,
750: TO_NUMBER(NULL) buyer_id,
751: sub.rowid row_id
752: FROM icx_por_oracle_item_subtable sub,
753: po_approved_supplier_list pasl
754: WHERE sub.rt_item_id = p_rt_item_id
755: AND sub.orc_template_id is null
756: AND sub.orc_contract_id is null

Line 786: FROM icx_por_oracle_item_subtable sub,

782: TO_CHAR(NULL) item_revision,
783: TO_NUMBER(NULL) line_type_id,
784: TO_NUMBER(NULL) buyer_id,
785: sub.rowid row_id
786: FROM icx_por_oracle_item_subtable sub,
787: icx_por_items item,
788: mtl_system_items msi
789: WHERE sub.rt_item_id = p_rt_item_id
790: AND sub.orc_template_id is null

Line 1389: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE

1385: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1386: raise ICX_POR_EXT_UTL.gException;
1387: END createTempCategoryItems;
1388:
1389: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE
1390: PROCEDURE moveExtractedPrices IS
1391: xErrLoc PLS_INTEGER;
1392: xReturnErr VARCHAR2(2000);
1393: xMode VARCHAR2(20) := 'EXTRACTED_PRICE';

Line 1409: 'ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE');

1405: END IF;
1406:
1407: xErrLoc := 100;
1408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1409: 'ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE');
1410:
1411: FORALL i IN 1..gEPRtItemIds.COUNT
1412: INSERT INTO ICX_CAT_ITEM_PRICES
1413: (rt_item_id, price_type,

Line 1454: FROM ICX_POR_ORACLE_ITEM_SUBTABLE sub,

1450: gEPItemRevisions(i), gEPLineTypeIds(i), gEPBuyerIds(i),
1451: NULL, gUpgradeUserId, gUpgradeUserId, sysdate,
1452: gUpgradeUserId, sub.creation_date, gUpgradePhaseId,
1453: gUpgradeUserId, gUpgradeUserId, sysdate
1454: FROM ICX_POR_ORACLE_ITEM_SUBTABLE sub,
1455: ICX_POR_ITEMS item
1456: WHERE sub.rowid = gEPRowIds(i)
1457: AND item.rt_item_id = sub.rt_item_id;
1458:

Line 2582: FROM icx_por_oracle_item_subtable sub

2578: WHERE NOT EXISTS (SELECT 'already upgraded'
2579: FROM icx_cat_items_b new_item
2580: WHERE item.rt_item_id = new_item.rt_item_id)
2581: AND (EXISTS (SELECT 'extracted price'
2582: FROM icx_por_oracle_item_subtable sub
2583: WHERE sub.rt_item_id = item.rt_item_id) OR
2584: EXISTS (SELECT 'bulkloaded price'
2585: FROM icx_por_price_list_lines pll
2586: WHERE pll.item_id = item.rt_item_id));