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_ID_LID

Line 423: MSC_TP_ID_LID tp,

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
427: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID

Line 453: --MSC_TP_ID_LID tp,

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
457: WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID

Line 625: ||' MSC_TP_ID_LID tp,'

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'
629: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msis.HIGHER_ITEM_ID'

Line 1998: FROM MSC_TP_ID_LID mtil,

1994: msis.FORECAST_HORIZON,
1995: msis.FIXED_ORDER_QUANTITY,
1996: /* SCE Change ends */
1997: msis.SR_INSTANCE_ID
1998: FROM MSC_TP_ID_LID mtil,
1999: MSC_TP_SITE_ID_LID mtsil,
2000: MSC_ITEM_ID_LID t1,
2001: MSC_ST_ITEM_SUPPLIERS msis,
2002: MSC_UNITS_OF_MEASURE muom

Line 2038: FROM MSC_TP_ID_LID mtil,

2034: mssc.FROM_DATE,
2035: mssc.TO_DATE,
2036: mssc.CAPACITY,
2037: mssc.SR_INSTANCE_ID
2038: FROM MSC_TP_ID_LID mtil,
2039: MSC_TP_SITE_ID_LID mtsil,
2040: MSC_ITEM_ID_LID t1,
2041: MSC_ST_SUPPLIER_CAPACITIES mssc
2042: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id

Line 2072: FROM MSC_TP_ID_LID mtil,

2068: mtsil.TP_SITE_ID SUPPLIER_SITE_ID,
2069: t1.INVENTORY_ITEM_ID,
2070: mssc.FROM_DATE,
2071: mssc.SR_INSTANCE_ID
2072: FROM MSC_TP_ID_LID mtil,
2073: MSC_TP_SITE_ID_LID mtsil,
2074: MSC_ITEM_ID_LID t1,
2075: MSC_ST_SUPPLIER_CAPACITIES mssc
2076: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id

Line 2095: FROM MSC_TP_ID_LID mtil,

2091: mtsil.TP_SITE_ID SUPPLIER_SITE_ID,
2092: t1.INVENTORY_ITEM_ID,
2093: mssc.FROM_DATE,
2094: mssc.SR_INSTANCE_ID
2095: FROM MSC_TP_ID_LID mtil,
2096: MSC_TP_SITE_ID_LID mtsil,
2097: MSC_ITEM_ID_LID t1,
2098: MSC_ST_SUPPLIER_CAPACITIES mssc,
2099: MSC_SUPPLIER_CAPACITIES msc1

Line 2127: FROM MSC_TP_ID_LID mtil,

2123: t1.INVENTORY_ITEM_ID, -- mssfe.INVENTORY_ITEM_ID,
2124: mssfe.FENCE_DAYS,
2125: mssfe.TOLERANCE_PERCENTAGE,
2126: mssfe.SR_INSTANCE_ID
2127: FROM MSC_TP_ID_LID mtil,
2128: MSC_TP_SITE_ID_LID mtsil,
2129: MSC_ITEM_ID_LID t1,
2130: MSC_ST_SUPPLIER_FLEX_FENCES mssfe
2131: WHERE t1.SR_INVENTORY_ITEM_ID= mssfe.inventory_item_id

Line 2145: FROM MSC_TP_ID_LID mtil,

2141: /*ASL */
2142: Cursor del_asl is
2143: SELECT T1.INVENTORY_ITEM_ID, msis.USING_ORGANIZATION_ID,
2144: mtil.TP_ID SUPPLIER_ID, mtsil.TP_SITE_ID SUPPLIER_SITE_ID
2145: FROM MSC_TP_ID_LID mtil,
2146: MSC_TP_SITE_ID_LID mtsil,
2147: MSC_ITEM_ID_LID t1,
2148: MSC_ST_ITEM_SUPPLIERS msis
2149: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id

Line 2200: FROM MSC_TP_ID_LID mtil,

2196: Msis.FORECAST_HORIZON,
2197: Msis.FIXED_ORDER_QUANTITY,
2198: /* SCE Change ends */
2199: Msis.SR_INSTANCE_ID
2200: FROM MSC_TP_ID_LID mtil,
2201: MSC_TP_SITE_ID_LID mtsil,
2202: MSC_ITEM_ID_LID t1,
2203: MSC_ST_ITEM_SUPPLIERS msis,
2204: MSC_UNITS_OF_MEASURE muom