eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 424: MSC_ITEM_ID_LID t1,

420: tp.TP_ID CUSTOMER_ID,
421: tps.TP_SITE_ID CUSTOMER_SITE_ID
422: FROM MSC_TP_SITE_ID_LID tps,
423: MSC_TP_ID_LID tp,
424: MSC_ITEM_ID_LID t1,
425: MSC_ITEM_ID_LID t2,
426: MSC_ST_ITEM_SUBSTITUTES msis
427: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
428: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID

Line 425: MSC_ITEM_ID_LID t2,

421: tps.TP_SITE_ID CUSTOMER_SITE_ID
422: FROM MSC_TP_SITE_ID_LID tps,
423: MSC_TP_ID_LID tp,
424: MSC_ITEM_ID_LID t1,
425: MSC_ITEM_ID_LID t2,
426: MSC_ST_ITEM_SUBSTITUTES msis
427: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
428: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID
429: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID

Line 454: MSC_ITEM_ID_LID t1,

450: nvl(msis.EFFECTIVE_DATE,sysdate) EFFECTIVE_DATE,
451: msis.DISABLE_DATE
452: FROM --MSC_TP_SITE_ID_LID tps,
453: --MSC_TP_ID_LID tp,
454: MSC_ITEM_ID_LID t1,
455: MSC_ITEM_ID_LID t2,
456: MSC_ST_ITEM_SUBSTITUTES msis
457: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
458: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID

Line 455: MSC_ITEM_ID_LID t2,

451: msis.DISABLE_DATE
452: FROM --MSC_TP_SITE_ID_LID tps,
453: --MSC_TP_ID_LID tp,
454: MSC_ITEM_ID_LID t1,
455: MSC_ITEM_ID_LID t2,
456: MSC_ST_ITEM_SUBSTITUTES msis
457: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
458: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID
459: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID

Line 626: ||' MSC_ITEM_ID_LID t1,'

622: ||' :v_current_date,'
623: ||' :v_current_user'
624: ||' FROM MSC_TP_SITE_ID_LID tps,'
625: ||' MSC_TP_ID_LID tp,'
626: ||' MSC_ITEM_ID_LID t1,'
627: ||' MSC_ITEM_ID_LID t2,'
628: ||' MSC_ST_ITEM_SUBSTITUTES msis'
629: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
630: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'

Line 627: ||' MSC_ITEM_ID_LID t2,'

623: ||' :v_current_user'
624: ||' FROM MSC_TP_SITE_ID_LID tps,'
625: ||' MSC_TP_ID_LID tp,'
626: ||' MSC_ITEM_ID_LID t1,'
627: ||' MSC_ITEM_ID_LID t2,'
628: ||' MSC_ST_ITEM_SUBSTITUTES msis'
629: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
630: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'
631: ||' AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID'

Line 684: ||' MSC_ITEM_ID_LID t1,'

680: ||' :v_current_user,'
681: ||' :v_current_date,'
682: ||' :v_current_user'
683: ||' FROM '
684: ||' MSC_ITEM_ID_LID t1,'
685: ||' MSC_ITEM_ID_LID t2,'
686: ||' MSC_ST_ITEM_SUBSTITUTES msis'
687: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
688: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'

Line 685: ||' MSC_ITEM_ID_LID t2,'

681: ||' :v_current_date,'
682: ||' :v_current_user'
683: ||' FROM '
684: ||' MSC_ITEM_ID_LID t1,'
685: ||' MSC_ITEM_ID_LID t2,'
686: ||' MSC_ST_ITEM_SUBSTITUTES msis'
687: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'
688: ||' AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID'
689: ||' AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID'

Line 753: MSC_ITEM_ID_LID t1,

749: DELETE FROM MSC_ITEM_SUBSTITUTES
750: WHERE ( HIGHER_ITEM_ID, LOWER_ITEM_ID, ORGANIZATION_ID, RELATIONSHIP_TYPE) in
751: ( select t1.INVENTORY_ITEM_ID, t2.INVENTORY_ITEM_ID, msis.ORGANIZATION_ID, msis.RELATIONSHIP_TYPE
752: from MSC_ST_ITEM_SUBSTITUTES msis,
753: MSC_ITEM_ID_LID t1,
754: MSC_ITEM_ID_LID t2
755: where
756: t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
757: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID

Line 754: MSC_ITEM_ID_LID t2

750: WHERE ( HIGHER_ITEM_ID, LOWER_ITEM_ID, ORGANIZATION_ID, RELATIONSHIP_TYPE) in
751: ( select t1.INVENTORY_ITEM_ID, t2.INVENTORY_ITEM_ID, msis.ORGANIZATION_ID, msis.RELATIONSHIP_TYPE
752: from MSC_ST_ITEM_SUBSTITUTES msis,
753: MSC_ITEM_ID_LID t1,
754: MSC_ITEM_ID_LID t2
755: where
756: t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID
757: AND t1.SR_INSTANCE_ID= msis.SR_INSTANCE_ID
758: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID

Line 1063: MSC_ITEM_ID_LID t1,

1059: msic.END_DATE_ACTIVE,
1060: msic.SR_INSTANCE_ID,
1061: msic.SR_CATEGORY_ID
1062: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1063: MSC_ITEM_ID_LID t1,
1064: MSC_ST_ITEM_CATEGORIES msic
1065: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1066: AND t1.sr_instance_id= msic.sr_instance_id
1067: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID

Line 1080: MSC_ITEM_ID_LID t1,

1076: mcsil.Category_Set_ID,
1077: msic.SR_INSTANCE_ID,
1078: msic.SR_CATEGORY_ID
1079: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1080: MSC_ITEM_ID_LID t1,
1081: MSC_ST_ITEM_CATEGORIES msic
1082: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1083: AND t1.sr_instance_id= msic.sr_instance_id
1084: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID

Line 1183: ||' MSC_ITEM_ID_LID t1,'

1179: ||' :v_current_user , '
1180: ||' :v_current_date , '
1181: ||' :v_current_user '
1182: ||' FROM MSC_CATEGORY_SET_ID_LID mcsil,'
1183: ||' MSC_ITEM_ID_LID t1,'
1184: ||' MSC_ST_ITEM_CATEGORIES msic'
1185: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msic.inventory_item_id '
1186: ||' AND t1.sr_instance_id = msic.sr_instance_id '
1187: ||' AND mcsil.SR_Category_Set_ID = msic.SR_Category_Set_ID '

Line 1511: from MSC_ITEM_ID_LID miil

1507: msi.SR_INVENTORY_ITEM_ID, msi.SR_INSTANCE_ID, mi.INVENTORY_ITEM_ID
1508: FROM MSC_ST_SYSTEM_ITEMS msi,
1509: MSC_ITEMS mi
1510: WHERE NOT EXISTS( select 1
1511: from MSC_ITEM_ID_LID miil
1512: where msi.SR_INVENTORY_ITEM_ID=
1513: miil.SR_INVENTORY_ITEM_ID
1514: and msi.SR_INSTANCE_ID= miil.SR_INSTANCE_ID)
1515: AND msi.ITEM_NAME= mi.ITEM_NAME

Line 1542: where table_name = 'MSC_ITEM_ID_LID';

1538: begin
1539: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1540: into lv_item_id_count, lv_items_stat_stale
1541: from dba_TAB_STATISTICS
1542: where table_name = 'MSC_ITEM_ID_LID';
1543: exception when no_data_found then
1544: lv_items_stat_stale := MSC_UTIL.SYS_YES ;
1545: end;
1546:

Line 1563: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1559:
1560: IF lv_control_flag = 2 THEN
1561:
1562: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1563: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1564: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1565: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1566: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1567: lv_items_stat_stale := MSC_UTIL.SYS_YES;

Line 1565: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;

1561:
1562: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1563: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1564: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1565: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1566: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1567: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1568: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1569: END IF;

Line 1574: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

1570:
1571: ELSE
1572:
1573: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1574: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1575: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1576: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1577: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1578: END IF;

Line 1591: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1587:
1588: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.org_group_flag =MSC_UTIL.G_ALL_ORGANIZATIONS ) THEN
1589:
1590: IF lv_control_flag = 2 THEN
1591: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1592: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1593: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;

Line 1593: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;

1589:
1590: IF lv_control_flag = 2 THEN
1591: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1592: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1593: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1596: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1597: ELSE

Line 1598: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

1594: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1595: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1596: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1597: ELSE
1598: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1599: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1600: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1601: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1602: END IF;

Line 1617: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

1613: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES) and
1614: (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) and (MSC_CL_COLLECTION.v_coll_prec.org_group_flag=MSC_UTIL.G_ALL_ORGANIZATIONS) THEN
1615:
1616: IF lv_control_flag = 2 THEN
1617: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1618: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1619: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;

Line 1619: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;

1615:
1616: IF lv_control_flag = 2 THEN
1617: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1618: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1619: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1622: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1623: ELSE

Line 1624: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');

1620: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1621: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1622: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1623: ELSE
1624: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1625: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1626: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1627: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1628: END IF;

Line 1693: INSERT INTO MSC_ITEM_ID_LID

1689: FOR c_rec IN c11 LOOP
1690:
1691: BEGIN
1692:
1693: INSERT INTO MSC_ITEM_ID_LID
1694: ( SR_INVENTORY_ITEM_ID,
1695: SR_INSTANCE_ID,
1696: INVENTORY_ITEM_ID)
1697: VALUES

Line 1713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');

1709:
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1715:
1716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1717: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');

1735:
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1741:
1742: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1743: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 1944: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');

1940:
1941: /* analyse the key mapping tables */
1942: IF MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES THEN
1943: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1944: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1945: END IF;
1946: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN
1947: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');
1948: END IF;

Line 2004: MSC_ITEM_ID_LID t1,

2000: /* SCE Change ends */
2001: msis.SR_INSTANCE_ID
2002: FROM MSC_TP_ID_LID mtil,
2003: MSC_TP_SITE_ID_LID mtsil,
2004: MSC_ITEM_ID_LID t1,
2005: MSC_ST_ITEM_SUPPLIERS msis,
2006: MSC_UNITS_OF_MEASURE muom
2007: -- MSC_UNITS_OF_MEASURE muom1
2008: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id

Line 2044: MSC_ITEM_ID_LID t1,

2040: mssc.CAPACITY,
2041: mssc.SR_INSTANCE_ID
2042: FROM MSC_TP_ID_LID mtil,
2043: MSC_TP_SITE_ID_LID mtsil,
2044: MSC_ITEM_ID_LID t1,
2045: MSC_ST_SUPPLIER_CAPACITIES mssc
2046: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2047: AND t1.sr_instance_id= mssc.sr_instance_id
2048: AND mtil.SR_TP_ID = mssc.SUPPLIER_ID

Line 2078: MSC_ITEM_ID_LID t1,

2074: mssc.FROM_DATE,
2075: mssc.SR_INSTANCE_ID
2076: FROM MSC_TP_ID_LID mtil,
2077: MSC_TP_SITE_ID_LID mtsil,
2078: MSC_ITEM_ID_LID t1,
2079: MSC_ST_SUPPLIER_CAPACITIES mssc
2080: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2081: AND t1.sr_instance_id= mssc.sr_instance_id
2082: AND mtil.SR_TP_ID = mssc.SUPPLIER_ID

Line 2101: MSC_ITEM_ID_LID t1,

2097: mssc.FROM_DATE,
2098: mssc.SR_INSTANCE_ID
2099: FROM MSC_TP_ID_LID mtil,
2100: MSC_TP_SITE_ID_LID mtsil,
2101: MSC_ITEM_ID_LID t1,
2102: MSC_ST_SUPPLIER_CAPACITIES mssc,
2103: MSC_SUPPLIER_CAPACITIES msc1
2104: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2105: AND t1.sr_instance_id= mssc.sr_instance_id

Line 2133: MSC_ITEM_ID_LID t1,

2129: mssfe.TOLERANCE_PERCENTAGE,
2130: mssfe.SR_INSTANCE_ID
2131: FROM MSC_TP_ID_LID mtil,
2132: MSC_TP_SITE_ID_LID mtsil,
2133: MSC_ITEM_ID_LID t1,
2134: MSC_ST_SUPPLIER_FLEX_FENCES mssfe
2135: WHERE t1.SR_INVENTORY_ITEM_ID= mssfe.inventory_item_id
2136: AND t1.sr_instance_id= mssfe.sr_instance_id
2137: AND mtil.SR_TP_ID = mssfe.SUPPLIER_ID

Line 2151: MSC_ITEM_ID_LID t1,

2147: SELECT T1.INVENTORY_ITEM_ID, msis.USING_ORGANIZATION_ID,
2148: mtil.TP_ID SUPPLIER_ID, mtsil.TP_SITE_ID SUPPLIER_SITE_ID
2149: FROM MSC_TP_ID_LID mtil,
2150: MSC_TP_SITE_ID_LID mtsil,
2151: MSC_ITEM_ID_LID t1,
2152: MSC_ST_ITEM_SUPPLIERS msis
2153: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id
2154: AND t1.sr_instance_id= msis.sr_instance_id
2155: AND mtil.SR_TP_ID = msis.SUPPLIER_ID

Line 2206: MSC_ITEM_ID_LID t1,

2202: /* SCE Change ends */
2203: Msis.SR_INSTANCE_ID
2204: FROM MSC_TP_ID_LID mtil,
2205: MSC_TP_SITE_ID_LID mtsil,
2206: MSC_ITEM_ID_LID t1,
2207: MSC_ST_ITEM_SUPPLIERS msis,
2208: MSC_UNITS_OF_MEASURE muom
2209: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id
2210: AND t1.sr_instance_id= msis.sr_instance_id

Line 3349: FROM MSC_ITEM_ID_LID t3,

3345: msi.REPAIR_PROGRAM,
3346: msi.UNSATISFIED_DEMAND_FACTOR,
3347: msi.MIN_SUP_DEM_PERCENT,
3348: msi.DMD_SATISFIED_PERCENT
3349: FROM MSC_ITEM_ID_LID t3,
3350: MSC_ITEM_ID_LID t2,
3351: MSC_ITEM_ID_LID t1,
3352: MSC_TRADING_PARTNERS mtp,
3353: MSC_ST_SYSTEM_ITEMS msi

Line 3350: MSC_ITEM_ID_LID t2,

3346: msi.UNSATISFIED_DEMAND_FACTOR,
3347: msi.MIN_SUP_DEM_PERCENT,
3348: msi.DMD_SATISFIED_PERCENT
3349: FROM MSC_ITEM_ID_LID t3,
3350: MSC_ITEM_ID_LID t2,
3351: MSC_ITEM_ID_LID t1,
3352: MSC_TRADING_PARTNERS mtp,
3353: MSC_ST_SYSTEM_ITEMS msi
3354: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id

Line 3351: MSC_ITEM_ID_LID t1,

3347: msi.MIN_SUP_DEM_PERCENT,
3348: msi.DMD_SATISFIED_PERCENT
3349: FROM MSC_ITEM_ID_LID t3,
3350: MSC_ITEM_ID_LID t2,
3351: MSC_ITEM_ID_LID t1,
3352: MSC_TRADING_PARTNERS mtp,
3353: MSC_ST_SYSTEM_ITEMS msi
3354: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id
3355: AND t1.sr_instance_id= msi.sr_instance_id

Line 4109: ||' FROM MSC_ITEM_ID_LID t3, '

4105: ||' :v_current_date , '
4106: ||' :v_current_user , '
4107: ||' msi.PEGGING_DEMAND_WINDOW_DAYS,'
4108: ||' msi.PEGGING_SUPPLY_WINDOW_DAYS '
4109: ||' FROM MSC_ITEM_ID_LID t3, '
4110: ||' MSC_ITEM_ID_LID t2, '
4111: ||' MSC_ITEM_ID_LID t1, '
4112: ||' MSC_TRADING_PARTNERS mtp, '
4113: ||' MSC_ST_SYSTEM_ITEMS msi '

Line 4110: ||' MSC_ITEM_ID_LID t2, '

4106: ||' :v_current_user , '
4107: ||' msi.PEGGING_DEMAND_WINDOW_DAYS,'
4108: ||' msi.PEGGING_SUPPLY_WINDOW_DAYS '
4109: ||' FROM MSC_ITEM_ID_LID t3, '
4110: ||' MSC_ITEM_ID_LID t2, '
4111: ||' MSC_ITEM_ID_LID t1, '
4112: ||' MSC_TRADING_PARTNERS mtp, '
4113: ||' MSC_ST_SYSTEM_ITEMS msi '
4114: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '

Line 4111: ||' MSC_ITEM_ID_LID t1, '

4107: ||' msi.PEGGING_DEMAND_WINDOW_DAYS,'
4108: ||' msi.PEGGING_SUPPLY_WINDOW_DAYS '
4109: ||' FROM MSC_ITEM_ID_LID t3, '
4110: ||' MSC_ITEM_ID_LID t2, '
4111: ||' MSC_ITEM_ID_LID t1, '
4112: ||' MSC_TRADING_PARTNERS mtp, '
4113: ||' MSC_ST_SYSTEM_ITEMS msi '
4114: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '
4115: ||' AND t1.sr_instance_id = msi.sr_instance_id '