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

VIEW: OZF.OZF_NA_CONC_EXCEPTIONS#

Object Details
Object Name: OZF_NA_CONC_EXCEPTIONS#
Object Type: VIEW
Owner: OZF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
NA_CONC_EXCEPTION_ID NUMBER
Yes
ACT_BUDGET_USED_BY_ID NUMBER

ARC_ACT_BUDGET_USED_BY VARCHAR2 (30)
BUDGET_SOURCE_TYPE VARCHAR2 (30)
BUDGET_SOURCE_ID NUMBER
Yes
REQUEST_AMOUNT NUMBER

REQUEST_CURRENCY VARCHAR2 (10)
REQUEST_DATE DATE

STATUS_CODE VARCHAR2 (30)
APPROVED_AMOUNT NUMBER

APPROVED_IN_CURRENCY VARCHAR2 (10)
APPROVAL_DATE DATE

APPROVER_ID NUMBER

TRANSFER_TYPE VARCHAR2 (30)
REQUESTER_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

PRODUCT_LEVEL_TYPE VARCHAR2 (30)
PRODUCT_ID NUMBER

CUST_ACCOUNT_ID NUMBER

UTILIZATION_TYPE VARCHAR2 (30)
ADJUSTMENT_DATE DATE

GL_DATE DATE

BILLTO_CUST_ACCOUNT_ID NUMBER

REFERENCE_TYPE VARCHAR2 (30)
REFERENCE_ID NUMBER

ORDER_LINE_ID NUMBER

ORG_ID NUMBER

Query Text

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


SELECT NA_CONC_EXCEPTION_ID
,      ACT_BUDGET_USED_BY_ID
,      ARC_ACT_BUDGET_USED_BY
,      BUDGET_SOURCE_TYPE
,      BUDGET_SOURCE_ID
,      REQUEST_AMOUNT
,      REQUEST_CURRENCY
,      REQUEST_DATE
,      STATUS_CODE
,      APPROVED_AMOUNT
,      APPROVED_IN_CURRENCY
,      APPROVAL_DATE
,      APPROVER_ID
,      TRANSFER_TYPE
,      REQUESTER_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      PRODUCT_LEVEL_TYPE
,      PRODUCT_ID
,      CUST_ACCOUNT_ID
,      UTILIZATION_TYPE
,      ADJUSTMENT_DATE
,      GL_DATE
,      BILLTO_CUST_ACCOUNT_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      ORDER_LINE_ID
,      ORG_ID
FROM OZF.OZF_NA_CONC_EXCEPTIONS#;

Dependencies

[top of page]

OZF.OZF_NA_CONC_EXCEPTIONS# references the following:

SchemaOZF
TableOZF_NA_CONC_EXCEPTIONS
OZF.OZF_NA_CONC_EXCEPTIONS# is referenced by following:

SchemaAPPS
SynonymOZF_NA_CONC_EXCEPTIONS