DBA Data[Home] [Help]

APPS.WIP_VALIDATE dependencies on MTL_PARAMETERS

Line 650: FROM mtl_parameters

646: END IF;
647:
648: SELECT 'VALID'
649: INTO l_dummy
650: FROM mtl_parameters
651: WHERE organization_code = p_organization_code;
652:
653: RETURN TRUE;
654:

Line 694: FROM mtl_parameters

690: END IF;
691:
692: SELECT 'VALID'
693: INTO l_dummy
694: FROM mtl_parameters
695: WHERE organization_id = p_organization_id;
696:
697: RETURN TRUE;
698:

Line 1812: FROM mtl_project_v mpv, mtl_parameters mp

1808: fnd_profile.put('MFG_ORGANIZATION_ID',p_organization_id);
1809:
1810: SELECT 'VALID'
1811: INTO l_dummy
1812: FROM mtl_project_v mpv, mtl_parameters mp
1813: WHERE mpv.project_id = p_project_id
1814: AND mp.organization_id = p_organization_id
1815: AND mp.project_reference_enabled = 1;
1816:

Line 2084: FROM pa_tasks_expend_v ptv, mtl_parameters mp

2080: END IF;
2081:
2082: SELECT 'VALID'
2083: INTO l_dummy
2084: FROM pa_tasks_expend_v ptv, mtl_parameters mp
2085: WHERE ptv.task_id = p_task_id
2086: AND ptv.project_id = p_project_id
2087: AND mp.organization_id = p_organization_id
2088: AND mp.project_reference_enabled = 1