DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on WIP_PARAMETERS

Line 2503: FROM wip_parameters

2499: IF(l_finite_scheduler_flag is null) THEN
2500:
2501: SELECT nvl(use_finite_scheduler,2)
2502: INTO l_finite_scheduler_flag
2503: FROM wip_parameters
2504: WHERE organization_id = l_ship_org;
2505:
2506: oe_debug_pub.add ('create_subassembly_jobs: ' || 'l_finite_scheduler_flag is '|| l_finite_scheduler_flag ,1);
2507:

Line 3045: FROM wip_parameters

3041: IF(l_finite_scheduler_flag is null) THEN
3042:
3043: SELECT nvl(use_finite_scheduler,2)
3044: INTO l_finite_scheduler_flag
3045: FROM wip_parameters
3046: WHERE organization_id = l_ship_org;
3047:
3048: oe_debug_pub.add ('create_subassembly_jobs: ' || 'l_finite_scheduler_flag is '|| l_finite_scheduler_flag ,1);
3049:

Line 3484: wip_parameters wp,

3480: )
3481:
3482: from bom_calendar_dates cal,
3483: mtl_parameters mp,
3484: wip_parameters wp,
3485: mtl_system_items msi
3486: where mp.organization_id = l_ship_org
3487: and wp.organization_id = mp.organization_id
3488: and msi.organization_id = l_ship_org

Line 3631: wip_parameters wp,

3627: l_mlsupply_items(l_index).job_start_date,
3628: null)
3629: from bom_calendar_dates cal,
3630: mtl_parameters mp,
3631: wip_parameters wp,
3632: mtl_system_items msi
3633: where mp.organization_id = l_ship_org
3634: and wp.organization_id = mp.organization_id
3635: and msi.organization_id = l_ship_org