APPS.INV_ITEM_DATA_SCRIPTS dependencies on MTL_SYSTEM_ITEMS_B

Line 21: UPDATE MTL_SYSTEM_ITEMS_B

17: BEGIN
18: FND_FILE.put_line (FND_FILE.log, 'Entered procedure proc_io_shippable_flags ');
19:
20: l_sql_stmt_num := 1;
21: UPDATE MTL_SYSTEM_ITEMS_B
22: SET INTERNAL_ORDER_ENABLED_FLAG ='N'
23: WHERE INTERNAL_ORDER_ENABLED_FLAG ='Y'
24: AND INTERNAL_ORDER_FLAG ='N';
25:

Line 27: UPDATE MTL_SYSTEM_ITEMS_B

23: WHERE INTERNAL_ORDER_ENABLED_FLAG ='Y'
24: AND INTERNAL_ORDER_FLAG ='N';
25:
26: l_sql_stmt_num := 2;
27: UPDATE MTL_SYSTEM_ITEMS_B
28: SET INTERNAL_ORDER_ENABLED_FLAG ='N',
29: INTERNAL_ORDER_FLAG ='N'
30: WHERE INTERNAL_ORDER_FLAG ='Y'
31: AND NVL(CONTRACT_ITEM_TYPE_CODE, 'SUBSCRIPTION') IN

Line 35: UPDATE MTL_SYSTEM_ITEMS_B

31: AND NVL(CONTRACT_ITEM_TYPE_CODE, 'SUBSCRIPTION') IN
32: ('WARRANTY','SERVICE','USAGE');
33:
34: l_sql_stmt_num := 3;
35: UPDATE MTL_SYSTEM_ITEMS_B
36: SET SHIPPABLE_ITEM_FLAG ='Y'
37: WHERE INTERNAL_ORDER_FLAG ='Y'
38: AND SHIPPABLE_ITEM_FLAG ='N'
39: AND NVL(CONTRACT_ITEM_TYPE_CODE, 'SUBSCRIPTION') NOT IN

Line 92: FROM mtl_system_items_b msib,

88: /*Retrieves all the child Organizations for the the specific item and master org combination */
89: CURSOR child_orgs(item_id NUMBER,
90: master_org_id NUMBER) IS
91: SELECT msib.organization_id
92: FROM mtl_system_items_b msib,
93: mtl_parameters mp
94: WHERE msib.organization_id = mp.organization_id
95: AND msib.inventory_item_id = item_id
96: AND mp.master_organization_id = master_org_id