View: AMW_EXPORT_KEY_ACC_V

Product:	AMW - Internal Controls Manager
Description:
Implementation/DBA Data:	APPS.AMW_EXPORT_KEY_ACC_V

View Text

SELECT DISTINCT 'PROC_HIER' ACC_CTX
, APHD.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID NATURAL_ACCOUNT_ID
, -100 AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
, AMW_PROC_HIERARCHY_DENORM APHD
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND APHD.PARENT_CHILD_ID=APV.PROCESS_ID
AND APHD.PROCESS_ID=-1
AND APHD.UP_DOWN_IND='D'
AND AAA.DELETION_DATE IS NULL
AND APHD.HIERARCHY_TYPE='L' UNION ALL SELECT DISTINCT 'PROC_BASIC' ACC_CTX
, APHD.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID
, -100 AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
, AMW_PROC_HIERARCHY_DENORM APHD
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND APHD.PARENT_CHILD_ID=APV.PROCESS_ID
AND APHD.PROCESS_ID <> -1
AND APHD.UP_DOWN_IND='D'
AND AAA.DELETION_DATE IS NULL
AND APHD.HIERARCHY_TYPE='L' UNION ALL SELECT DISTINCT 'PROC_BASIC' ACC_CTX
, APV.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID
, -100 AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AAA.DELETION_DATE IS NULL UNION ALL SELECT DISTINCT 'PROC_HIER' ACC_CTX
, APHD.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID
, AORV.PARTY_ID AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
, AMW_PROC_HIERARCHY_DENORM APHD
, AMW_OWNER_ROLES_V AORV
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND APHD.PARENT_CHILD_ID=APV.PROCESS_ID
AND APHD.PROCESS_ID=-1
AND APHD.UP_DOWN_IND='D'
AND AORV.ROLE_NAME='AMW_RL_PROC_OWNER_ROLE'
AND APV.PROCESS_ID=AORV.PK1_VALUE
AND AAA.DELETION_DATE IS NULL
AND APHD.HIERARCHY_TYPE='L' UNION ALL SELECT DISTINCT 'PROC_BASIC' ACC_CTX
, APHD.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID
, AORV.PARTY_ID AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
, AMW_PROC_HIERARCHY_DENORM APHD
, AMW_OWNER_ROLES_V AORV
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND APHD.PARENT_CHILD_ID=APV.PROCESS_ID
AND APHD.PROCESS_ID <> -1
AND APHD.UP_DOWN_IND='D'
AND AORV.ROLE_NAME='AMW_RL_PROC_OWNER_ROLE'
AND APV.PROCESS_ID=AORV.PK1_VALUE
AND AAA.DELETION_DATE IS NULL
AND APHD.HIERARCHY_TYPE='L' UNION ALL SELECT DISTINCT 'PROC_BASIC' ACC_CTX
, APV.PROCESS_ID ACC_PPID
, APV.DISPLAY_NAME PDN
, AFKAT.NAME ANM
, AFKAB.NATURAL_ACCOUNT_VALUE
, AFKAB.NATURAL_ACCOUNT_ID
, AORV.PARTY_ID AS PARTY_ID
FROM AMW_PROCESS_VL APV
, AMW_ACCT_ASSOCIATIONS AAA
, AMW_FIN_KEY_ACCOUNTS_B AFKAB
, AMW_FIN_KEY_ACCOUNTS_TL AFKAT
, AMW_OWNER_ROLES_V AORV
WHERE AAA.OBJECT_TYPE='PROCESS'
AND AAA.PK1=APV.PROCESS_ID
AND APV.END_DATE IS NULL
AND AAA.NATURAL_ACCOUNT_ID=AFKAB.NATURAL_ACCOUNT_ID
AND AFKAT.LANGUAGE=USERENV('LANG')
AND AFKAB.END_DATE IS NULL
AND AFKAB.PARENT_NATURAL_ACCOUNT_ID IS NULL
AND AFKAB.ACCOUNT_GROUP_ID=AFKAT.ACCOUNT_GROUP_ID
AND AFKAB.NATURAL_ACCOUNT_ID=AFKAT.NATURAL_ACCOUNT_ID
AND AORV.ROLE_NAME='AMW_RL_PROC_OWNER_ROLE'
AND APV.PROCESS_ID=AORV.PK1_VALUE
AND AAA.DELETION_DATE IS NULL

Columns