DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on MTL_PARAMETERS

Line 942: FROM mtl_parameters

938:
939: -- Cursor to get all
940: CURSOR All_Orgs IS
941: SELECT DISTINCT organization_id
942: FROM mtl_parameters
943: WHERE process_enabled_flag <> 'Y'; -- Added to exclude process orgs after R12 uptake
944:
945:
946: x_date_from DATE;

Line 3463: FROM mtl_parameters

3459: ******************************************************** */
3460: CURSOR All_Orgs is
3461: SELECT distinct
3462: organization_id
3463: FROM mtl_parameters
3464: WHERE process_enabled_flag <> 'Y'; -- Added to exclude process orgs after R12 uptake
3465:
3466: x_phase VARCHAR2(10);
3467: x_org_id NUMBER;

Line 4119: FROM mtl_parameters

4115: Cursor to get all valid inventory organizations
4116: **************************************************************/
4117: CURSOR All_Orgs is
4118: SELECT distinct organization_id
4119: FROM mtl_parameters
4120: WHERE organization_id = nvl(p_organization_id, organization_id)
4121: AND process_enabled_flag <> 'Y'; -- Added to exclude process orgs after R12 uptake
4122:
4123: x_date_from DATE;

Line 4585: FROM mtl_parameters

4581: Cursor to get all valid inventory organizations
4582: **************************************************************/
4583: CURSOR All_Orgs is
4584: SELECT distinct organization_id
4585: FROM mtl_parameters
4586: WHERE organization_id = nvl(p_organization_id, organization_id)
4587: AND process_enabled_flag <> 'Y'; -- Added to exclude process orgs after R12 uptake
4588:
4589: x_date_from DATE;