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;
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;
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;
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;