APPS.MSC_CL_ITEM_PULL dependencies on MSC_ST_ITEM_CATEGORIES

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

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

Line 33: ' insert into MSC_ST_ITEM_CATEGORIES'

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

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

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

Line 145: 'insert into MSC_ST_ITEM_CATEGORIES'

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

Line 1710: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category

1706:
1707: lv_table_name:= 'MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1708:
1709:
1710: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category
1711: where st_item_category.INVENTORY_ITEM_ID in ( -1000,-1001) and
1712: st_item_category.SR_CATEGORY_SET_ID in (-5000)and
1713: st_item_category.SR_CATEGORY_ID in (-5001) and
1714: st_item_category.sr_instance_id = MSC_CL_PULL.v_instance_id and

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

1736: lv_category_id := -5001;
1737: END ;
1738:
1739: lv_table_name :='MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1740: lv_sql_stmt := 'insert into MSC_ST_ITEM_CATEGORIES ('
1741: ||'INVENTORY_ITEM_ID,'
1742: ||'ORGANIZATION_ID,'
1743: ||'SR_CATEGORY_SET_ID,'
1744: ||'SR_CATEGORY_ID, '

Line 1782: update MSC_ST_ITEM_CATEGORIES set DESCRIPTION = lv_category_description

1778: execute immediate lv_sql_stmt using lv_item_id ;
1779:
1780: end loop;
1781:
1782: update MSC_ST_ITEM_CATEGORIES set DESCRIPTION = lv_category_description
1783: where INVENTORY_ITEM_ID in (-1001,-1000)
1784: and SR_CATEGORY_SET_ID = lv_category_set_id
1785: and SR_CATEGORY_ID = lv_category_id
1786: and organization_id in