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 607: ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||

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' ||
609: ' multi_org_flag = ''Y'')) V';
610:
611: statement:= 'MERGE INTO ' ||X_table_name||' targ'||