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_SNAPSHOT_PK dependencies on MSC_SYSTEM_ITEMS

Line 2111: from msc_system_items items, msc_item_categories cat, msc_plans plans

2107: select items.inventory_item_id,
2108: cat.organization_id,
2109: cat.sr_instance_id,
2110: cat.sr_category_id
2111: from msc_system_items items, msc_item_categories cat, msc_plans plans
2112: where cat.CATEGORY_SET_ID = plans.CATEGORY_SET_ID
2113: and cat.inventory_item_id = items.inventory_item_id
2114: and cat.sr_instance_id = items.sr_instance_id
2115: and cat.organization_id = items.organization_id

Line 2128: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');

2124: WHERE plan_id = p_plan_id;
2125:
2126: IF (lv_plan_partition_exists > 0) THEN
2127:
2128: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
2129:
2130: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2131:
2132: ELSE

Line 2130: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);

2126: IF (lv_plan_partition_exists > 0) THEN
2127:
2128: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
2129:
2130: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2131:
2132: ELSE
2133:
2134: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');

Line 2134: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');

2130: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2131:
2132: ELSE
2133:
2134: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
2135:
2136: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
2137:
2138: null;

Line 2136: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );

2132: ELSE
2133:
2134: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
2135:
2136: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
2137:
2138: null;
2139:
2140: END IF;

Line 2168: UPDATE MSC_SYSTEM_ITEMS

2164: lv_fetchComplete := TRUE;
2165: END IF;
2166:
2167: FORALL j IN lb_inv_item_id.FIRST..lb_inv_item_id.LAST
2168: UPDATE MSC_SYSTEM_ITEMS
2169: SET sr_category_id = lb_sr_category_id(j)
2170: WHERE sr_instance_id = lb_sr_instance_id(j)
2171: AND inventory_item_id = lb_inv_item_id(j)
2172: AND organization_id = lb_org_id(j)

Line 2224: SELECT /+ ORDERED USE_NL(ODS, MSC_SYSTEM_ITEMS_U1) / ODS.INVENTORY_ITEM_ID,

2220: lv_plan_partition_exists Number := 0;
2221:
2222: CURSOR items_for_update
2223: IS
2224: SELECT /*+ ORDERED USE_NL(ODS, MSC_SYSTEM_ITEMS_U1) */ ODS.INVENTORY_ITEM_ID,
2225: PDS.ORGANIZATION_ID,
2226: ODS.SR_INSTANCE_ID,
2227: ODS.ITEM_NAME,
2228: ODS.DESCRIPTION,

Line 2234: FROM MSC_SYSTEM_ITEMS PDS,

2230: ODS.PLANNER_CODE,
2231: ODS.PLANNING_EXCEPTION_SET,
2232: ODS.REVISION,
2233: -1
2234: FROM MSC_SYSTEM_ITEMS PDS,
2235: MSC_SYSTEM_ITEMS_V ODS
2236: WHERE ODS.PLAN_ID = -1
2237: AND ODS.PDS_PLAN_ID = PDS.PLAN_ID
2238: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID

Line 2235: MSC_SYSTEM_ITEMS_V ODS

2231: ODS.PLANNING_EXCEPTION_SET,
2232: ODS.REVISION,
2233: -1
2234: FROM MSC_SYSTEM_ITEMS PDS,
2235: MSC_SYSTEM_ITEMS_V ODS
2236: WHERE ODS.PLAN_ID = -1
2237: AND ODS.PDS_PLAN_ID = PDS.PLAN_ID
2238: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID
2239: AND ODS.ORGANIZATION_ID = DECODE(PDS.ORGANIZATION_ID, -1,

Line 2252: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');

2248: WHERE plan_id = p_plan_id;
2249:
2250: IF (lv_plan_partition_exists > 0) THEN
2251:
2252: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
2253:
2254: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2255:
2256: ELSE

Line 2254: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);

2250: IF (lv_plan_partition_exists > 0) THEN
2251:
2252: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
2253:
2254: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2255:
2256: ELSE
2257:
2258: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');

Line 2258: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');

2254: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
2255:
2256: ELSE
2257:
2258: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
2259:
2260: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
2261:
2262: null;

Line 2260: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );

2256: ELSE
2257:
2258: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
2259:
2260: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
2261:
2262: null;
2263:
2264: END IF;

Line 2298: UPDATE /+ index (items MSC_SYSTEM_ITEMS_U1) /

2294: lv_fetchComplete := TRUE;
2295: END IF;
2296:
2297: FORALL j IN lb_inv_item_id.FIRST..lb_inv_item_id.LAST
2298: UPDATE /*+ index (items MSC_SYSTEM_ITEMS_U1) */
2299: MSC_SYSTEM_ITEMS items
2300: SET item_name = lb_item_name(j),
2301: description = lb_description(j),
2302: buyer_name = lb_buyer_name(j),

Line 2299: MSC_SYSTEM_ITEMS items

2295: END IF;
2296:
2297: FORALL j IN lb_inv_item_id.FIRST..lb_inv_item_id.LAST
2298: UPDATE /*+ index (items MSC_SYSTEM_ITEMS_U1) */
2299: MSC_SYSTEM_ITEMS items
2300: SET item_name = lb_item_name(j),
2301: description = lb_description(j),
2302: buyer_name = lb_buyer_name(j),
2303: planner_code = lb_planner_code(j),