DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_APINV_APPROVERS#

Object Details
Object Name: AP_APINV_APPROVERS#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15)
INVOICE_ITERATION NUMBER (15)
INVOICE_KEY VARCHAR2 (50)
LINE_NUMBER NUMBER (15)
NOTIFICATION_ITERATION NUMBER (15)
NOTIFICATION_KEY VARCHAR2 (50)
NOTIFICATION_STATUS VARCHAR2 (50)
ROLE_NAME VARCHAR2 (320)
ORIG_SYSTEM VARCHAR2 (30)
ORIG_SYSTEM_ID NUMBER (15)
DISPLAY_NAME VARCHAR2 (360)
APPROVER_CATEGORY VARCHAR2 (1)
API_INSERTION VARCHAR2 (1)
AUTHORITY VARCHAR2 (1)
APPROVAL_STATUS VARCHAR2 (50)
ACTION_TYPE_ID NUMBER (15)
GROUP_OR_CHAIN_ID NUMBER (15)
OCCURRENCE NUMBER (15)
SOURCE VARCHAR2 (500)
ITEM_CLASS VARCHAR2 (50)
ITEM_ID VARCHAR2 (50)
ITEM_CLASS_ORDER_NUMBER NUMBER (15)
ITEM_ORDER_NUMBER NUMBER (15)
SUB_LIST_ORDER_NUMBER NUMBER (15)
ACTION_TYPE_ORDER_NUMBER NUMBER (15)
GROUP_OR_CHAIN_ORDER_NUMBER NUMBER (15)
MEMBER_ORDER_NUMBER NUMBER (15)
APPROVER_ORDER_NUMBER NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
EXTERNAL_ROLE_NAME VARCHAR2 (320)
ACCESS_CONTROL_FLAG VARCHAR2 (1)
CHILD_PROCESS_ITEM_TYPE VARCHAR2 (50)
CHILD_PROCESS_ITEM_KEY VARCHAR2 (50)
ITEM_TYPE VARCHAR2 (50)
ITEM_KEY VARCHAR2 (50)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      INVOICE_ITERATION
,      INVOICE_KEY
,      LINE_NUMBER
,      NOTIFICATION_ITERATION
,      NOTIFICATION_KEY
,      NOTIFICATION_STATUS
,      ROLE_NAME
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      DISPLAY_NAME
,      APPROVER_CATEGORY
,      API_INSERTION
,      AUTHORITY
,      APPROVAL_STATUS
,      ACTION_TYPE_ID
,      GROUP_OR_CHAIN_ID
,      OCCURRENCE
,      SOURCE
,      ITEM_CLASS
,      ITEM_ID
,      ITEM_CLASS_ORDER_NUMBER
,      ITEM_ORDER_NUMBER
,      SUB_LIST_ORDER_NUMBER
,      ACTION_TYPE_ORDER_NUMBER
,      GROUP_OR_CHAIN_ORDER_NUMBER
,      MEMBER_ORDER_NUMBER
,      APPROVER_ORDER_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      EXTERNAL_ROLE_NAME
,      ACCESS_CONTROL_FLAG
,      CHILD_PROCESS_ITEM_TYPE
,      CHILD_PROCESS_ITEM_KEY
,      ITEM_TYPE
,      ITEM_KEY
FROM AP.AP_APINV_APPROVERS#;

Dependencies

[top of page]

AP.AP_APINV_APPROVERS# references the following:

SchemaAP
TableAP_APINV_APPROVERS
AP.AP_APINV_APPROVERS# is referenced by following:

SchemaAPPS
SynonymAP_APINV_APPROVERS