APPS.CSD_REPAIRS_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 2344: -- MRP_PLANNED_FLAG = 6 in mtl_system_items_b for a particular item.

2340: -- check if the need by date profile is set up properly. The requisition import program
2341: -- needs the need by date for MRP or INV planned items. Right now we assume that all items
2342: -- are planned.
2343: -- the need by date can possibly be left null only when INVENTORY_PLANNED_FLAG = 6 and
2344: -- MRP_PLANNED_FLAG = 6 in mtl_system_items_b for a particular item.
2345: l_dummy := to_number(fnd_profile.value('CSD_REQUISITION_LEAD_TIME'));
2346:
2347: if nvl(l_dummy,-1) <= -1 then
2348: FND_MESSAGE.SET_NAME('CSD','CSD_REQ_LEAD_TIME_NOT_SET');

Line 3373: FROM mtl_system_items_b

3369:
3370: -- get the service item defaults.
3371: SELECT service_duration_period_code, service_duration, service_starting_delay
3372: INTO l_service_durn_period_code,l_service_duration,l_service_starting_delay
3373: FROM mtl_system_items_b
3374: WHERE inventory_item_id = l_service_item_id
3375: AND organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
3376:
3377: -- the service item is not null, create the line in OM.