APPS.MSC_CL_ITEM_PULL dependencies on MSC_ST_ITEM_CATEGORIES

Line 32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';

28:
29: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
30:
31: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_CATEGORIES_V';
34: v_sql_stmt:=
35: ' insert into MSC_ST_ITEM_CATEGORIES'
36: ||'( INVENTORY_ITEM_ID,'

Line 35: ' insert into MSC_ST_ITEM_CATEGORIES'

31: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_CATEGORIES_V';
34: v_sql_stmt:=
35: ' insert into MSC_ST_ITEM_CATEGORIES'
36: ||'( INVENTORY_ITEM_ID,'
37: ||' ORGANIZATION_ID,'
38: ||' SR_CATEGORY_SET_ID,'
39: ||' SR_CATEGORY_ID,'

Line 60: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';

56: COMMIT;
57: END IF; --- Incremental refresh
58:
59:
60: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';
61: MSC_CL_PULL.v_view_name := 'MRP_AP_ITEM_CATEGORIES_V';
62:
63: /* Bug 4365337 - don't need the diff. RNs since Rn1, RN3 and RN4 are anyway 0.
64: We need to check only for RN2 (both in 11i and rel 11.0)

Line 147: 'insert into MSC_ST_ITEM_CATEGORIES'

143: END IF;
144:
145:
146: v_sql_stmt:=
147: 'insert into MSC_ST_ITEM_CATEGORIES'
148: ||' ( INVENTORY_ITEM_ID,'
149: ||' ORGANIZATION_ID,'
150: ||' SR_CATEGORY_SET_ID,'
151: ||' SR_CATEGORY_ID,'

Line 1910: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category

1906:
1907: lv_table_name:= 'MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1908:
1909:
1910: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category
1911: where st_item_category.INVENTORY_ITEM_ID in ( -1000,-1001,-1002,-1003,-1004) and
1912: st_item_category.SR_CATEGORY_SET_ID in (-5000)and
1913: st_item_category.SR_CATEGORY_ID in (-5001) and
1914: st_item_category.sr_instance_id = MSC_CL_PULL.v_instance_id and

Line 1940: lv_sql_stmt := 'insert into MSC_ST_ITEM_CATEGORIES ('

1936: lv_category_id := -5001;
1937: END ;
1938:
1939: lv_table_name :='MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1940: lv_sql_stmt := 'insert into MSC_ST_ITEM_CATEGORIES ('
1941: ||'INVENTORY_ITEM_ID,'
1942: ||'ORGANIZATION_ID,'
1943: ||'SR_CATEGORY_SET_ID,'
1944: ||'SR_CATEGORY_ID, '

Line 1982: update MSC_ST_ITEM_CATEGORIES set DESCRIPTION = lv_category_description

1978: execute immediate lv_sql_stmt using lv_item_id ;
1979:
1980: end loop;
1981:
1982: update MSC_ST_ITEM_CATEGORIES set DESCRIPTION = lv_category_description
1983: where INVENTORY_ITEM_ID in (-1004,-1003,-1002,-1001,-1000)
1984: and SR_CATEGORY_SET_ID = lv_category_set_id
1985: and SR_CATEGORY_ID = lv_category_id
1986: and organization_id in