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

VIEW: OKS.OKS_BATCH_RULES#

Object Details
Object Name: OKS_BATCH_RULES#
Object Type: VIEW
Owner: OKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes
BATCH_TYPE VARCHAR2 (30)
BATCH_SOURCE VARCHAR2 (30)
TRANSACTION_DATE DATE

CREDIT_OPTION VARCHAR2 (30)
TERMINATION_REASON_CODE VARCHAR2 (30)
BILLING_PROFILE_ID NUMBER

RETAIN_CONTRACT_NUMBER_FLAG VARCHAR2 (1)
CONTRACT_MODIFIER VARCHAR2 (120)
CONTRACT_STATUS VARCHAR2 (30)
TRANSFER_NOTES_FLAG VARCHAR2 (1)
TRANSFER_ATTACHMENTS_FLAG VARCHAR2 (1)
BILL_LINES_FLAG VARCHAR2 (1)
TRANSFER_OPTION_CODE VARCHAR2 (30)
BILL_ACCOUNT_ID NUMBER

SHIP_ACCOUNT_ID NUMBER

BILL_ADDRESS_ID NUMBER

SHIP_ADDRESS_ID NUMBER

BILL_CONTACT_ID NUMBER

NEW_ACCOUNT_ID NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Yes
REQUEST_ID NUMBER

Query Text

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


SELECT BATCH_ID
,      BATCH_TYPE
,      BATCH_SOURCE
,      TRANSACTION_DATE
,      CREDIT_OPTION
,      TERMINATION_REASON_CODE
,      BILLING_PROFILE_ID
,      RETAIN_CONTRACT_NUMBER_FLAG
,      CONTRACT_MODIFIER
,      CONTRACT_STATUS
,      TRANSFER_NOTES_FLAG
,      TRANSFER_ATTACHMENTS_FLAG
,      BILL_LINES_FLAG
,      TRANSFER_OPTION_CODE
,      BILL_ACCOUNT_ID
,      SHIP_ACCOUNT_ID
,      BILL_ADDRESS_ID
,      SHIP_ADDRESS_ID
,      BILL_CONTACT_ID
,      NEW_ACCOUNT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
FROM OKS.OKS_BATCH_RULES#;

Dependencies

[top of page]

OKS.OKS_BATCH_RULES# references the following:

SchemaOKS
TableOKS_BATCH_RULES
OKS.OKS_BATCH_RULES# is referenced by following:

SchemaAPPS
SynonymOKS_BATCH_RULES