DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on WIP_PARAMETERS

Line 2490: FROM wip_parameters

2486: IF(l_finite_scheduler_flag is null) THEN
2487:
2488: SELECT nvl(use_finite_scheduler,2)
2489: INTO l_finite_scheduler_flag
2490: FROM wip_parameters
2491: WHERE organization_id = l_ship_org;
2492:
2493: oe_debug_pub.add ('create_subassembly_jobs: ' || 'l_finite_scheduler_flag is '|| l_finite_scheduler_flag ,1);
2494:

Line 3032: FROM wip_parameters

3028: IF(l_finite_scheduler_flag is null) THEN
3029:
3030: SELECT nvl(use_finite_scheduler,2)
3031: INTO l_finite_scheduler_flag
3032: FROM wip_parameters
3033: WHERE organization_id = l_ship_org;
3034:
3035: oe_debug_pub.add ('create_subassembly_jobs: ' || 'l_finite_scheduler_flag is '|| l_finite_scheduler_flag ,1);
3036:

Line 3447: wip_parameters wp,

3443: )
3444:
3445: from bom_calendar_dates cal,
3446: mtl_parameters mp,
3447: wip_parameters wp,
3448: mtl_system_items msi
3449: where mp.organization_id = l_ship_org
3450: and wp.organization_id = mp.organization_id
3451: and msi.organization_id = l_ship_org

Line 3595: wip_parameters wp,

3591: l_mlsupply_items(l_index).job_start_date,
3592: null)
3593: from bom_calendar_dates cal,
3594: mtl_parameters mp,
3595: wip_parameters wp,
3596: mtl_system_items msi
3597: where mp.organization_id = l_ship_org
3598: and wp.organization_id = mp.organization_id
3599: and msi.organization_id = l_ship_org