APPS.BOMPCMBM dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 320: FROM ORG_ORGANIZATION_DEFINITIONS

316: /* Get the "common org to" Organization code */
317: IF (scope = 1) AND (common_org_to is not null) THEN
318: SELECT organization_code
319: INTO common_org_to_code
320: FROM ORG_ORGANIZATION_DEFINITIONS
321: WHERE Organization_id = common_org_to ;
322: END IF ;
323:
324: /* Get the "common Item to" item id */

Line 358: FROM org_organization_definitions

354: IF ( scope = 2 ) THEN
355: starting_org_counter := 2 ;
356: SELECT organization_name
357: INTO l_org_name
358: FROM org_organization_definitions
359: WHERE organization_id = current_org_id;
360: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(org_hierarchy,current_org_id,t_org_code_list) ;
361: ELSIF ( scope = 3 ) THEN
362: starting_org_counter := 1 ;

Line 393: FROM ORG_ORGANIZATION_DEFINITIONS

389: END IF;
390:
391: SELECT organization_code
392: INTO l_org_code
393: FROM ORG_ORGANIZATION_DEFINITIONS
394: WHERE organization_id = current_org_id ;
395:
396: /*** Loop through the organization in the list of organizations ***/
397: FOR I in starting_org_counter..t_org_code_list.LAST LOOP

Line 402: FROM ORG_ORGANIZATION_DEFINITIONS

398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));
399:
400: SELECT organization_code
401: INTO l_org_code_to
402: FROM ORG_ORGANIZATION_DEFINITIONS
403: WHERE organization_id = t_org_code_list(I) ;
404:
405: item_not_found := 0 ;
406: IF (scope = 2 OR scope = 3) THEN