DBA Data[Home] [Help]

APPS.AD_MORG dependencies on DUAL

Line 21: from dual

17: where product_group_id = 1
18: and multi_org_flag = 'Y'
19: union
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')

Line 583: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||

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' ||
585: ' multi_org_flag = ''Y'')) V';
586:
587: statement := 'INSERT INTO ' || X_table_name || ' (' ||