Skip to content

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

TABLE: OKS.OKS_INT_HEADER_STG_TEMP

Object Details
Object Name: OKS_INT_HEADER_STG_TEMP
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_INT_HEADER_STG_TEMP
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
HEADER_INTERFACE_ID NUMBER

HEADER_INTERFACE_ROWID ROWID (10)
CONTRACT_NUMBER VARCHAR2 (120)
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
INTERFACE_STATUS VARCHAR2 (1)
CATEGORY VARCHAR2 (30)
STATUS_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

KNOWN_AS VARCHAR2 (300)
DESCRIPTION VARCHAR2 (1995)
INV_ORGANIZATION_ID NUMBER

OPERATING_UNIT_ID NUMBER

BILL_TO_SITE_USAGE_ID NUMBER

SHIP_TO_SITE_USAGE_ID NUMBER

CONTRACT_CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_DATE DATE

PRICE_LIST_ID NUMBER

PAYMENT_TERMS_ID NUMBER (15)
PAYMENT_INSTRUCTION VARCHAR2 (3)
PO_REQUIRED VARCHAR2 (3)
PAYMENT_INSTRUCTION_DETAILS VARCHAR2 (150)
INVOICING_RULE_ID NUMBER (15)
SERVICE_CHRG_PREPAY_REQ VARCHAR2 (1)
RENEWAL_PROCESS VARCHAR2 (30)
APPROVAL_REQUIRED VARCHAR2 (30)
RENEW_UP_TO DATE

DATE_APPROVED DATE

DATE_SIGNED DATE

DATE_CANCELED DATE

CANCELLATION_REASON VARCHAR2 (30)
QA_CHECKLIST NUMBER

PAYMENT_METHOD_CODE VARCHAR2 (30)
COMMITMENT_ID NUMBER

TAX_EXEMPTION_CONTROL VARCHAR2 (30)
TAX_EXEMPTION_NUMBER VARCHAR2 (80)
EXEMPT_REASON_CODE VARCHAR2 (30)
BILL_SERVICES VARCHAR2 (1)
BILLING_TRANSACTION_TYPE_ID NUMBER

ACCOUNTING_RULE_ID NUMBER

HOLD_CREDITS VARCHAR2 (1)
SUMMARY_PRINT VARCHAR2 (1)
SUMMARY_TRANSACTIONS VARCHAR2 (1)
SERVICE_CHARGES_PO_REQUIRED VARCHAR2 (1)
SERVICE_CHARGES_PO_NUMBER VARCHAR2 (240)
PRICING_METHOD VARCHAR2 (30)
RENEWAL_PRICE_LIST_ID NUMBER

RENEWAL_MARKUP NUMBER

RENEWAL_BILLING_PROFILE_ID NUMBER

RENEWAL_PO_NUMBER VARCHAR2 (240)
RENEWAL_PO_REQUIRED VARCHAR2 (1)
RENEWAL_GRACE_DURATION NUMBER

RENEWAL_GRACE_PERIOD VARCHAR2 (30)
RENEWAL_ESTIMATED_PERCENT NUMBER

RENEWAL_ESTIMATED_DURATION NUMBER

RENEWAL_ESTIMATED_PERIOD VARCHAR2 (30)
QUOTE_TO_PARTY_SITE NUMBER

QUOTE_TO_CONTACT NUMBER

QUOTE_TO_PHONE NUMBER

QUOTE_TO_FAX NUMBER

QUOTE_TO_EMAIL NUMBER

GRACE_DURATION NUMBER

GRACE_PERIOD VARCHAR2 (30)
ESTIMATION_PERCENT NUMBER

ESTIMATION_DATE DATE

FOLLOW_UP_DUE_DATE DATE

FOLLOW_UP_ACTION VARCHAR2 (30)
CUSTOMER_PARTY_ID NUMBER

THIRD_PARTY_ID NUMBER

CONTRACT_GROUP_ID NUMBER

APPROVAL_PROCESS_ID NUMBER

AGREEMENT_ID NUMBER

SALESPERSON_ID NUMBER

CUSTOMER_CONTRACT_ADMIN_ID NUMBER

SALESGROUP_ID NUMBER

FULLY_BILLED VARCHAR2 (1)
SOURCE VARCHAR2 (80)
DOCUMENT VARCHAR2 (240)
Query Text

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


SELECT HEADER_INTERFACE_ID
,      HEADER_INTERFACE_ROWID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      INTERFACE_STATUS
,      CATEGORY
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      KNOWN_AS
,      DESCRIPTION
,      INV_ORGANIZATION_ID
,      OPERATING_UNIT_ID
,      BILL_TO_SITE_USAGE_ID
,      SHIP_TO_SITE_USAGE_ID
,      CONTRACT_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      PRICE_LIST_ID
,      PAYMENT_TERMS_ID
,      PAYMENT_INSTRUCTION
,      PO_REQUIRED
,      PAYMENT_INSTRUCTION_DETAILS
,      INVOICING_RULE_ID
,      SERVICE_CHRG_PREPAY_REQ
,      RENEWAL_PROCESS
,      APPROVAL_REQUIRED
,      RENEW_UP_TO
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_CANCELED
,      CANCELLATION_REASON
,      QA_CHECKLIST
,      PAYMENT_METHOD_CODE
,      COMMITMENT_ID
,      TAX_EXEMPTION_CONTROL
,      TAX_EXEMPTION_NUMBER
,      EXEMPT_REASON_CODE
,      BILL_SERVICES
,      BILLING_TRANSACTION_TYPE_ID
,      ACCOUNTING_RULE_ID
,      HOLD_CREDITS
,      SUMMARY_PRINT
,      SUMMARY_TRANSACTIONS
,      SERVICE_CHARGES_PO_REQUIRED
,      SERVICE_CHARGES_PO_NUMBER
,      PRICING_METHOD
,      RENEWAL_PRICE_LIST_ID
,      RENEWAL_MARKUP
,      RENEWAL_BILLING_PROFILE_ID
,      RENEWAL_PO_NUMBER
,      RENEWAL_PO_REQUIRED
,      RENEWAL_GRACE_DURATION
,      RENEWAL_GRACE_PERIOD
,      RENEWAL_ESTIMATED_PERCENT
,      RENEWAL_ESTIMATED_DURATION
,      RENEWAL_ESTIMATED_PERIOD
,      QUOTE_TO_PARTY_SITE
,      QUOTE_TO_CONTACT
,      QUOTE_TO_PHONE
,      QUOTE_TO_FAX
,      QUOTE_TO_EMAIL
,      GRACE_DURATION
,      GRACE_PERIOD
,      ESTIMATION_PERCENT
,      ESTIMATION_DATE
,      FOLLOW_UP_DUE_DATE
,      FOLLOW_UP_ACTION
,      CUSTOMER_PARTY_ID
,      THIRD_PARTY_ID
,      CONTRACT_GROUP_ID
,      APPROVAL_PROCESS_ID
,      AGREEMENT_ID
,      SALESPERSON_ID
,      CUSTOMER_CONTRACT_ADMIN_ID
,      SALESGROUP_ID
,      FULLY_BILLED
,      SOURCE
,      DOCUMENT
FROM OKS.OKS_INT_HEADER_STG_TEMP;

Dependencies

[top of page]

OKS.OKS_INT_HEADER_STG_TEMP does not reference any database object

OKS.OKS_INT_HEADER_STG_TEMP is referenced by following:

SchemaOKS
ViewOKS_INT_HEADER_STG_TEMP#