[Home] [Help]
97: = BET_MUST_HAVE.COMPONENT_ITEM_ID
98: AND BET.GROUP_ID = c_grp_id
99: AND BET.PLAN_LEVEL = c_counter
100: AND EXISTS (SELECT 'Costing must be enabled'
101: FROM MTL_SYSTEM_ITEMS
102: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
103: AND ORGANIZATION_ID = c_org_id
104: AND COSTING_ENABLED_FLAG = 'Y');
105:
143: AND CIC_DEF.INVENTORY_ITEM_ID(+) = BET_MUST_HAVE.COMPONENT_ITEM_ID
144: AND BET.GROUP_ID = c_grp_id
145: AND BET.PLAN_LEVEL = c_counter
146: AND EXISTS (SELECT 'Costing must be enabled'
147: FROM MTL_SYSTEM_ITEMS
148: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
149: AND ORGANIZATION_ID = c_org_id
150: AND COSTING_ENABLED_FLAG = 'Y');
151:
295: AND BET.PLAN_LEVEL = counter
296: AND BET.TOP_BILL_SEQUENCE_ID = l_top_bill_id(i)
297: AND BET.ROWID = l_row_id(i)
298: AND EXISTS (SELECT 'Costing must be enabled'
299: FROM MTL_SYSTEM_ITEMS
300: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
301: AND ORGANIZATION_ID = org_id);
302: END LOOP;
303:
355: = BET_MUST_HAVE.COMPONENT_ITEM_ID)
356: WHERE BET.GROUP_ID = grp_id
357: AND BET.PLAN_LEVEL = counter
358: AND EXISTS (SELECT 'Costing must be enabled'
359: FROM MTL_SYSTEM_ITEMS
360: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
361: AND ORGANIZATION_ID = org_id
362: AND COSTING_ENABLED_FLAG = 'Y');
363:
452: = BET_MUST_HAVE.COMPONENT_ITEM_ID)
453: WHERE BET.GROUP_ID = grp_id
454: AND BET.PLAN_LEVEL = counter
455: AND EXISTS (SELECT 'Costing must be enabled'
456: FROM MTL_SYSTEM_ITEMS
457: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
458: AND ORGANIZATION_ID = org_id
459: AND COSTING_ENABLED_FLAG = 'Y');
460:
514: AND BET.PLAN_LEVEL = counter
515: AND BET.TOP_BILL_SEQUENCE_ID = l_top_bill_id(i)
516: AND BET.ROWID = l_row_id(i)
517: AND EXISTS (SELECT 'Costing must be enabled'
518: FROM MTL_SYSTEM_ITEMS
519: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
520: AND ORGANIZATION_ID = org_id);
521: END LOOP;
522: