DBA Data[Home] [Help]

APPS.MRP_DEFAULT_FLOW_SCHEDULE dependencies on MTL_SYSTEM_ITEMS

Line 1156: FROM MTL_SYSTEM_ITEMS

1152:
1153: SELECT NVL(FIXED_LEAD_TIME,0),
1154: NVL(VARIABLE_LEAD_TIME,0)
1155: INTO l_fixed_lead_time, l_variable_lead_time
1156: FROM MTL_SYSTEM_ITEMS
1157: WHERE INVENTORY_ITEM_ID = g_flow_schedule_rec.primary_item_id
1158: AND ORGANIZATION_ID = g_flow_schedule_rec.organization_id;
1159:
1160: SELECT start_time, stop_time,maximum_rate