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

TABLE: OZF.OZF_NA_CONC_EXCEPTIONS

Object Details
Object Name: OZF_NA_CONC_EXCEPTIONS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_NA_CONC_EXCEPTIONS
Subobject Name:
Status: VALID


This table stores unsuccessful creation of utilization by Net Accrual concurrent engine. The exceptions will be re-submitted for creation during next execution of Net Accrual concurrent program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
NA_CONC_EXCEPTION_ID NUMBER
Yes Unique Identifier
ACT_BUDGET_USED_BY_ID NUMBER

Unique identifier of the object that uses the budget
ARC_ACT_BUDGET_USED_BY VARCHAR2 (30)
Object used by the Budget
BUDGET_SOURCE_TYPE VARCHAR2 (30)
Budget source type
BUDGET_SOURCE_ID NUMBER
Yes Budget source identifier
REQUEST_AMOUNT NUMBER

Request Amount
REQUEST_CURRENCY VARCHAR2 (10)
Request Currency
REQUEST_DATE DATE

Request Date
STATUS_CODE VARCHAR2 (30)
Status Code
APPROVED_AMOUNT NUMBER

Approved Amount
APPROVED_IN_CURRENCY VARCHAR2 (10)
Approved In Currency
APPROVAL_DATE DATE

Approval Date
APPROVER_ID NUMBER

Approver Id
TRANSFER_TYPE VARCHAR2 (30)
Transfer Type
REQUESTER_ID NUMBER

Requester Id
OBJECT_TYPE VARCHAR2 (30)
Object Type
OBJECT_ID NUMBER

Object Id
PRODUCT_LEVEL_TYPE VARCHAR2 (30)
Product Level Type
PRODUCT_ID NUMBER

Product Id
CUST_ACCOUNT_ID NUMBER

Cust Account Id
UTILIZATION_TYPE VARCHAR2 (30)
Utilization Type
ADJUSTMENT_DATE DATE

Adjustment Date
GL_DATE DATE

Gl Date
BILLTO_CUST_ACCOUNT_ID NUMBER

Billto Cust Account Id
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_ID NUMBER

Reference Id
ORDER_LINE_ID NUMBER

Order Line Id
ORG_ID NUMBER

Org Id
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 does not reference any database object

OZF.OZF_NA_CONC_EXCEPTIONS is referenced by following:

SchemaAPPS
SynonymOZF_NA_CONC_EXCEPTIONS