APPS.AD_MORG dependencies on FND_PRODUCT_GROUPS

Line 16: , fnd_product_groups

12: --
13: cursor org_cursor is
14: select organization_id
15: from hr_operating_units
16: , fnd_product_groups
17: where product_group_id = 1
18: and multi_org_flag = 'Y'
19: union
20: select to_number(null)

Line 24: from fnd_product_groups

20: select to_number(null)
21: from dual
22: where not exists (
23: select null
24: from fnd_product_groups
25: where multi_org_flag = 'Y')
26: order by 1;
27:
28: MSG_LEVEL_WARN CONSTANT BINARY_INTEGER := 1;

Line 604: ' fnd_product_groups, hr_operating_units' ||

600: raise table_not_found;
601: end if;
602:
603: in_line_view := ' (SELECT /*+ no_merge */ ORGANIZATION_ID FROM' ||
604: ' fnd_product_groups, hr_operating_units' ||
605: ' WHERE product_group_id = 1' ||
606: ' AND multi_org_flag = ''Y'' UNION' ||
607: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
608: ' (SELECT NULL FROM fnd_product_groups WHERE' ||

Line 608: ' (SELECT NULL FROM fnd_product_groups WHERE' ||

604: ' fnd_product_groups, hr_operating_units' ||
605: ' WHERE product_group_id = 1' ||
606: ' AND multi_org_flag = ''Y'' UNION' ||
607: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
608: ' (SELECT NULL FROM fnd_product_groups WHERE' ||
609: ' multi_org_flag = ''Y'')) V';
610:
611: statement:= 'MERGE INTO ' ||X_table_name||' targ'||
612: ' USING (SELECT '||column_list||' V.ORGANIZATION_ID '||

Line 710: from fnd_product_groups

706: -- use min() to return a value even if no rows (fresh install case)
707: --
708: select nvl(min(multi_org_flag),'N')
709: into is_org
710: from fnd_product_groups
711: where product_group_id = 1;
712:
713: if X_org_id is not null and is_org <> 'Y' then
714: return;

Line 1613: , fnd_product_groups

1609:
1610: select count(*)
1611: into l_num_org
1612: from hr_operating_units
1613: , fnd_product_groups
1614: where product_group_id = 1
1615: and multi_org_flag = 'Y';
1616:
1617: return(l_num_org);