APPS.BOMPCMBM dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 222: FROM ORG_ORGANIZATION_DEFINITIONS

218: /* Get the "common org to" Organization code */
219: IF (scope = 1) AND (common_org_to is not null) THEN
220: SELECT organization_code
221: INTO common_org_to_code
222: FROM ORG_ORGANIZATION_DEFINITIONS
223: WHERE Organization_id = common_org_to ;
224: END IF ;
225:
226: /* Get the "common Item to" item id */

Line 260: FROM org_organization_definitions

256: IF ( scope = 2 ) THEN
257: starting_org_counter := 2 ;
258: SELECT organization_name
259: INTO l_org_name
260: FROM org_organization_definitions
261: WHERE organization_id = current_org_id;
262: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(org_hierarchy,current_org_id,t_org_code_list) ;
263: ELSIF ( scope = 3 ) THEN
264: starting_org_counter := 1 ;

Line 295: FROM ORG_ORGANIZATION_DEFINITIONS

291: END IF;
292:
293: SELECT organization_code
294: INTO l_org_code
295: FROM ORG_ORGANIZATION_DEFINITIONS
296: WHERE organization_id = current_org_id ;
297:
298: /*** Loop through the organization in the list of organizations ***/
299: FOR I in starting_org_counter..t_org_code_list.LAST LOOP

Line 304: FROM ORG_ORGANIZATION_DEFINITIONS

300: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));
301:
302: SELECT organization_code
303: INTO l_org_code_to
304: FROM ORG_ORGANIZATION_DEFINITIONS
305: WHERE organization_id = t_org_code_list(I) ;
306:
307: item_not_found := 0 ;
308: IF (scope = 2 OR scope = 3) THEN