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_TP_SITE_ID_LID

Line 422: FROM MSC_TP_SITE_ID_LID tps,

418: msis.RELATIONSHIP_TYPE,
419: msis.PARTIAL_FULFILLMENT_FLAG,
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

Line 452: FROM --MSC_TP_SITE_ID_LID tps,

448: msis.RELATIONSHIP_TYPE,
449: msis.PARTIAL_FULFILLMENT_FLAG,
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

Line 624: ||' FROM MSC_TP_SITE_ID_LID tps,'

620: ||' :v_current_user,'
621: ||' :v_current_user,'
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'

Line 2003: MSC_TP_SITE_ID_LID mtsil,

1999: msis.FIXED_ORDER_QUANTITY,
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

Line 2043: MSC_TP_SITE_ID_LID mtsil,

2039: mssc.TO_DATE,
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

Line 2077: MSC_TP_SITE_ID_LID mtsil,

2073: t1.INVENTORY_ITEM_ID,
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

Line 2100: MSC_TP_SITE_ID_LID mtsil,

2096: t1.INVENTORY_ITEM_ID,
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

Line 2132: MSC_TP_SITE_ID_LID mtsil,

2128: mssfe.FENCE_DAYS,
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

Line 2150: MSC_TP_SITE_ID_LID mtsil,

2146: Cursor del_asl is
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

Line 2205: MSC_TP_SITE_ID_LID mtsil,

2201: Msis.FIXED_ORDER_QUANTITY,
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