[Home] [Help]
99: = BET_MUST_HAVE.COMPONENT_ITEM_ID
100: AND BET.GROUP_ID = c_grp_id
101: AND BET.PLAN_LEVEL = c_counter
102: AND EXISTS (SELECT 'Costing must be enabled'
103: FROM MTL_SYSTEM_ITEMS
104: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
105: AND ORGANIZATION_ID = c_org_id
106: AND COSTING_ENABLED_FLAG = 'Y');
107:
145: AND CIC_DEF.INVENTORY_ITEM_ID(+) = BET_MUST_HAVE.COMPONENT_ITEM_ID
146: AND BET.GROUP_ID = c_grp_id
147: AND BET.PLAN_LEVEL = c_counter
148: AND EXISTS (SELECT 'Costing must be enabled'
149: FROM MTL_SYSTEM_ITEMS
150: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
151: AND ORGANIZATION_ID = c_org_id
152: AND COSTING_ENABLED_FLAG = 'Y');
153:
297: AND BET.PLAN_LEVEL = counter
298: AND BET.TOP_BILL_SEQUENCE_ID = l_top_bill_id(i)
299: AND BET.ROWID = l_row_id(i)
300: AND EXISTS (SELECT 'Costing must be enabled'
301: FROM MTL_SYSTEM_ITEMS
302: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
303: AND ORGANIZATION_ID = org_id);
304: END LOOP;
305:
359: = BET_MUST_HAVE.COMPONENT_ITEM_ID)
360: WHERE BET.GROUP_ID = grp_id
361: AND BET.PLAN_LEVEL = counter
362: AND EXISTS (SELECT 'Costing must be enabled'
363: FROM MTL_SYSTEM_ITEMS
364: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
365: AND ORGANIZATION_ID = org_id
366: AND COSTING_ENABLED_FLAG = 'Y');
367:
458: = BET_MUST_HAVE.COMPONENT_ITEM_ID)
459: WHERE BET.GROUP_ID = grp_id
460: AND BET.PLAN_LEVEL = counter
461: AND EXISTS (SELECT 'Costing must be enabled'
462: FROM MTL_SYSTEM_ITEMS
463: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
464: AND ORGANIZATION_ID = org_id
465: AND COSTING_ENABLED_FLAG = 'Y');
466:
520: AND BET.PLAN_LEVEL = counter
521: AND BET.TOP_BILL_SEQUENCE_ID = l_top_bill_id(i)
522: AND BET.ROWID = l_row_id(i)
523: AND EXISTS (SELECT 'Costing must be enabled'
524: FROM MTL_SYSTEM_ITEMS
525: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
526: AND ORGANIZATION_ID = org_id);
527: END LOOP;
528: