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

VIEW: APPS.OKX_BUS_PROCESS_TXNS_V

Object Details
Object Name: OKX_BUS_PROCESS_TXNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_BUS_PROCESS_TXNS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays transactions associated with transaction groups.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Yes Unique key to identify a business process transaction
ID2 NUMBER (15) Yes The transaction associated with a transaction group; foreign key to CS_TRANSACTION_TYPES
NAME VARCHAR2 (0)
Name
STATUS VARCHAR2 (1)
Status
DESCRIPTION VARCHAR2 (0)
Description
START_DATE_ACTIVE DATE

Effective start date of the transaction associated with the transaction group
END_DATE_ACTIVE DATE

Effective end date of the transaction associated with the transaction group
INVENTORY_ITEM_ID VARCHAR2 (0)
Inventory item identifier
ORGANIZATION_ID VARCHAR2 (0)
Organization identifier
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measure code
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      STATUS
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_UOM_CODE
FROM APPS.OKX_BUS_PROCESS_TXNS_V;

Dependencies

[top of page]

APPS.OKX_BUS_PROCESS_TXNS_V references the following:

SchemaAPPS
SynonymCS_BUS_PROCESS_TXNS

APPS.OKX_BUS_PROCESS_TXNS_V is not referenced by any database object