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 580: ' fnd_product_groups, hr_operating_units' ||

576: c_pk.column_name || ' = A.' || c_pk.column_name;
577: end loop;
578:
579: in_line_view := ' (SELECT /*+ no_merge */ ORGANIZATION_ID FROM' ||
580: ' fnd_product_groups, hr_operating_units' ||
581: ' WHERE product_group_id = 1' ||
582: ' AND multi_org_flag = ''Y'' UNION' ||
583: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
584: ' (SELECT NULL FROM fnd_product_groups WHERE' ||

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

580: ' fnd_product_groups, hr_operating_units' ||
581: ' WHERE product_group_id = 1' ||
582: ' AND multi_org_flag = ''Y'' UNION' ||
583: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
584: ' (SELECT NULL FROM fnd_product_groups WHERE' ||
585: ' multi_org_flag = ''Y'')) V';
586:
587: statement := 'INSERT INTO ' || X_table_name || ' (' ||
588: column_list || 'ORG_ID)' ||

Line 670: from fnd_product_groups

666: -- use min() to return a value even if no rows (fresh install case)
667: --
668: select nvl(min(multi_org_flag),'N')
669: into is_org
670: from fnd_product_groups
671: where product_group_id = 1;
672:
673: if X_org_id is not null and is_org <> 'Y' then
674: return;

Line 1571: , fnd_product_groups

1567:
1568: select count(*)
1569: into l_num_org
1570: from hr_operating_units
1571: , fnd_product_groups
1572: where product_group_id = 1
1573: and multi_org_flag = 'Y';
1574:
1575: return(l_num_org);