eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: OKS.OKS_HEADERS_INTERFACE#

Object Details

Object Name:	OKS_HEADERS_INTERFACE#
Object Type:	VIEW
Owner:	OKS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
HEADER_INTERFACE_ID	NUMBER		Yes
CONTRACT_NUMBER	VARCHAR2	(120)	Yes
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)
CATEGORY	VARCHAR2	(30)	Yes
START_DATE	DATE		Yes
END_DATE	DATE		Yes
STATUS_CODE	VARCHAR2	(240)	Yes
KNOWN_AS	VARCHAR2	(300)
DESCRIPTION	VARCHAR2	(1995)	Yes
OPERATING_UNIT_ID	NUMBER		Yes
CUSTOMER_PARTY_NAME	VARCHAR2	(360)
CUSTOMER_PARTY_NUMBER	VARCHAR2	(30)
CUSTOMER_PARTY_ID	NUMBER
THIRD_PARTY_NAME	VARCHAR2	(360)
THIRD_PARTY_NUMBER	VARCHAR2	(30)
THIRD_PARTY_ID	NUMBER
BILL_TO_SITE_USAGE_CODE	VARCHAR2	(40)
BILL_TO_SITE_USAGE_ID	NUMBER
SHIP_TO_SITE_USAGE_CODE	VARCHAR2	(40)
SHIP_TO_SITE_USAGE_ID	NUMBER
SALESPERSON_NAME	VARCHAR2	(360)
SALESPERSON_ID	NUMBER
SALESGROUP_ID	NUMBER
CUSTOMER_CONTRACT_ADMIN_NAME	VARCHAR2	(360)
CUSTOMER_CONTRACT_ADMIN_ID	NUMBER
CONTRACT_CURRENCY_CODE	VARCHAR2	(15)	Yes
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_DATE	DATE
AGREEMENT_NAME	VARCHAR2	(240)
AGREEMENT_ID	NUMBER
PRICE_LIST_NAME	VARCHAR2	(240)
PRICE_LIST_ID	NUMBER
PAYMENT_TERMS_NAME	VARCHAR2	(15)
PAYMENT_TERMS_ID	NUMBER
PAYMENT_INSTRUCTION	VARCHAR2	(3)
PO_REQUIRED	VARCHAR2	(3)
PAYMENT_INSTRUCTION_DETAILS	VARCHAR2	(150)
PAYMENT_METHOD_CODE	VARCHAR2	(30)
COMMITMENT_ID	NUMBER
TAX_EXEMPTION_CONTROL	VARCHAR2	(30)
TAX_EXEMPTION_NUMBER	VARCHAR2	(80)
BILL_SERVICES	VARCHAR2	(1)
BILLING_TRANSACTION_TYPE_ID	NUMBER
ACCOUNTING_RULE_NAME	VARCHAR2	(30)
ACCOUNTING_RULE_ID	NUMBER
INVOICING_RULE_NAME	VARCHAR2	(30)
INVOICING_RULE_ID	NUMBER
HOLD_CREDITS	VARCHAR2	(1)
SUMMARY_PRINT	VARCHAR2	(1)
SUMMARY_TRANSACTIONS	VARCHAR2	(1)
SERVICE_CHRG_PREPAY_REQ	VARCHAR2	(1)
SERVICE_CHARGES_PO_REQUIRED	VARCHAR2	(1)
SERVICE_CHARGES_PO_NUMBER	VARCHAR2	(240)
RENEWAL_PROCESS	VARCHAR2	(30)
APPROVAL_REQUIRED	VARCHAR2	(30)
RENEW_UP_TO	DATE
PRICING_METHOD	VARCHAR2	(30)
RENEWAL_PRICE_LIST_NAME	VARCHAR2	(240)
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
DATE_APPROVED	DATE
DATE_SIGNED	DATE
DATE_CANCELED	DATE
CANCELLATION_REASON	VARCHAR2	(30)
GRACE_DURATION	NUMBER
GRACE_PERIOD	VARCHAR2	(30)
ESTIMATION_PERCENT	NUMBER
ESTIMATION_DATE	DATE
FOLLOW_UP_DUE_DATE	DATE
FOLLOW_UP_ACTION	VARCHAR2	(30)
QA_CHECKLIST	NUMBER
CONTRACT_GROUP_NAME	VARCHAR2	(150)
CONTRACT_GROUP_ID	NUMBER
APPROVAL_PROCESS_ID	NUMBER
FULLY_BILLED	VARCHAR2	(1)	Yes
SOURCE	VARCHAR2	(80)
DOCUMENT	VARCHAR2	(240)
INTERFACE_STATUS	VARCHAR2	(1)
INV_ORGANIZATION_ID	NUMBER
EXEMPT_REASON_CODE	VARCHAR2	(30)
BATCH_ID	NUMBER		Yes
PARENT_REQUEST_ID	NUMBER

Query Text

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


SELECT HEADER_INTERFACE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      CATEGORY
,      START_DATE
,      END_DATE
,      STATUS_CODE
,      KNOWN_AS
,      DESCRIPTION
,      OPERATING_UNIT_ID
,      CUSTOMER_PARTY_NAME
,      CUSTOMER_PARTY_NUMBER
,      CUSTOMER_PARTY_ID
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_ID
,      BILL_TO_SITE_USAGE_CODE
,      BILL_TO_SITE_USAGE_ID
,      SHIP_TO_SITE_USAGE_CODE
,      SHIP_TO_SITE_USAGE_ID
,      SALESPERSON_NAME
,      SALESPERSON_ID
,      SALESGROUP_ID
,      CUSTOMER_CONTRACT_ADMIN_NAME
,      CUSTOMER_CONTRACT_ADMIN_ID
,      CONTRACT_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      PAYMENT_TERMS_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_INSTRUCTION
,      PO_REQUIRED
,      PAYMENT_INSTRUCTION_DETAILS
,      PAYMENT_METHOD_CODE
,      COMMITMENT_ID
,      TAX_EXEMPTION_CONTROL
,      TAX_EXEMPTION_NUMBER
,      BILL_SERVICES
,      BILLING_TRANSACTION_TYPE_ID
,      ACCOUNTING_RULE_NAME
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_NAME
,      INVOICING_RULE_ID
,      HOLD_CREDITS
,      SUMMARY_PRINT
,      SUMMARY_TRANSACTIONS
,      SERVICE_CHRG_PREPAY_REQ
,      SERVICE_CHARGES_PO_REQUIRED
,      SERVICE_CHARGES_PO_NUMBER
,      RENEWAL_PROCESS
,      APPROVAL_REQUIRED
,      RENEW_UP_TO
,      PRICING_METHOD
,      RENEWAL_PRICE_LIST_NAME
,      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
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_CANCELED
,      CANCELLATION_REASON
,      GRACE_DURATION
,      GRACE_PERIOD
,      ESTIMATION_PERCENT
,      ESTIMATION_DATE
,      FOLLOW_UP_DUE_DATE
,      FOLLOW_UP_ACTION
,      QA_CHECKLIST
,      CONTRACT_GROUP_NAME
,      CONTRACT_GROUP_ID
,      APPROVAL_PROCESS_ID
,      FULLY_BILLED
,      SOURCE
,      DOCUMENT
,      INTERFACE_STATUS
,      INV_ORGANIZATION_ID
,      EXEMPT_REASON_CODE
,      BATCH_ID
,      PARENT_REQUEST_ID
FROM OKS.OKS_HEADERS_INTERFACE#;

Dependencies

[top of page]

OKS.OKS_HEADERS_INTERFACE# references the following:

OKS: OKS_HEADERS_INTERFACE

OKS.OKS_HEADERS_INTERFACE# is referenced by following:

APPS: OKS_HEADERS_INTERFACE