[Home] [Help] [Dependency Information]
Object Name: | OZF_NA_CONC_EXCEPTIONS# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|