APPS.MSC_SNAPSHOT_PK dependencies on MSC_SYSTEM_ITEMS

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

1906: lv_plan_partition_exists Number := 0;
1907:
1908: CURSOR items_for_update
1909: IS
1910: SELECT /*+ ORDERED USE_NL(ODS, MSC_SYSTEM_ITEMS_U1) */ ODS.INVENTORY_ITEM_ID,
1911: PDS.ORGANIZATION_ID,
1912: ODS.SR_INSTANCE_ID,
1913: ODS.ITEM_NAME,
1914: ODS.DESCRIPTION,

Line 1920: FROM MSC_SYSTEM_ITEMS PDS,

1916: ODS.PLANNER_CODE,
1917: ODS.PLANNING_EXCEPTION_SET,
1918: ODS.REVISION,
1919: -1
1920: FROM MSC_SYSTEM_ITEMS PDS,
1921: MSC_SYSTEM_ITEMS ODS
1922: WHERE ODS.PLAN_ID = -1
1923: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID
1924: AND ODS.ORGANIZATION_ID = DECODE(PDS.ORGANIZATION_ID, -1,

Line 1921: MSC_SYSTEM_ITEMS ODS

1917: ODS.PLANNING_EXCEPTION_SET,
1918: ODS.REVISION,
1919: -1
1920: FROM MSC_SYSTEM_ITEMS PDS,
1921: MSC_SYSTEM_ITEMS ODS
1922: WHERE ODS.PLAN_ID = -1
1923: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID
1924: AND ODS.ORGANIZATION_ID = DECODE(PDS.ORGANIZATION_ID, -1,
1925: msc_snapshot_pk.get_validation_org_id(PDS.SR_INSTANCE_ID), PDS.ORGANIZATION_ID)

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

1933: WHERE plan_id = p_plan_id;
1934:
1935: IF (lv_plan_partition_exists > 0) THEN
1936:
1937: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
1938:
1939: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
1940:
1941: ELSE

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

1935: IF (lv_plan_partition_exists > 0) THEN
1936:
1937: LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS plan partition ');
1938:
1939: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
1940:
1941: ELSE
1942:
1943: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');

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

1939: msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS', -1, p_plan_id);
1940:
1941: ELSE
1942:
1943: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
1944:
1945: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
1946:
1947: null;

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

1941: ELSE
1942:
1943: -- LOG_MESSAGE('Analysing MSC_SYSTEM_ITEMS table ');
1944:
1945: -- msc_analyse_tables_pk.analyse_table( 'MSC_SYSTEM_ITEMS' );
1946:
1947: null;
1948:
1949: END IF;

Line 1983: UPDATE MSC_SYSTEM_ITEMS

1979: lv_fetchComplete := TRUE;
1980: END IF;
1981:
1982: FORALL j IN lb_inv_item_id.FIRST..lb_inv_item_id.LAST
1983: UPDATE MSC_SYSTEM_ITEMS
1984: SET item_name = lb_item_name(j),
1985: description = lb_description(j),
1986: buyer_name = lb_buyer_name(j),
1987: planner_code = lb_planner_code(j),