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]

TABLE: OZF.OZF_SD_REQUEST_HEADERS_ALL_B

Object Details

Object Name:	OZF_SD_REQUEST_HEADERS_ALL_B
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_SD_REQUEST_HEADERS_ALL_B
Subobject Name:
Status:	VALID

stores the ship and debit request header information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_SD_REQUEST_HDRS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_HEADER_ID
OZF_SD_REQUEST_HDRS_ALL_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OFFER_ID
OZF_SD_REQUEST_HDRS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_ID SUPPLIER_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_HEADER_ID	NUMBER		Yes	unique identifier
OBJECT_VERSION_NUMBER	NUMBER		Yes	object version number
LAST_UPDATE_DATE	DATE		Yes	Std WHO col.
LAST_UPDATED_BY	NUMBER		Yes	Std WHO col.
CREATION_DATE	DATE		Yes	Std WHO col.
CREATED_BY	NUMBER		Yes	Std WHO col.
LAST_UPDATE_LOGIN	NUMBER			Std WHO col.
REQUEST_ID	NUMBER			Std WHO col.
PROGRAM_APPLICATION_ID	NUMBER			Std WHO col.
PROGRAM_UPDATE_DATE	DATE			Std WHO col.
PROGRAM_ID	NUMBER			Std WHO col.
CREATED_FROM	VARCHAR2	(30)		Std WHO col.
REQUEST_NUMBER	VARCHAR2	(30)	Yes	Auto generated/manual entry request number. Request Number that is seen on SD Request Summary page
REQUEST_CLASS	VARCHAR2	(30)		Request classification. This col value will classify the SD request. May be used for future use.
OFFER_TYPE	VARCHAR2	(30)		Type of offer submitted to TM module
OFFER_ID	NUMBER			Promotional Offer Identifier. Foreign key for ozf_offers.
ROOT_REQUEST_HEADER_ID	NUMBER			For Future Use
LINKED_REQUEST_HEADER_ID	NUMBER			For Future Use
REQUEST_START_DATE	DATE			SD Request start date. Corresponds to start date filed on SDR Header creation page
REQUEST_END_DATE	DATE			SD Request end date. Corresponds to end date filed on SDR Header creation page
REQUEST_OUTCOME	VARCHAR2	(30)		Outcome code for the SD Request. possible values : IN PROGRESS / REJECTED / ACCEPTED
DECLINE_REASON_CODE	VARCHAR2	(30)		Can be derived from Lookups.
RETURN_REASON_CODE	VARCHAR2	(30)		Can be derived from Lookups.
REQUEST_CURRENCY_CODE	VARCHAR2	(15)		Currency Code
AUTHORIZATION_NUMBER	VARCHAR2	(30)		Authorization number of SD request
REQUESTED_BUDGET_AMOUNT	NUMBER			Requested budget amount. For future use.
APPROVED_BUDGET_AMOUNT	NUMBER			Approved budget amount. For future use.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
SUPPLIER_ID	NUMBER			supplier id
SUPPLIER_SITE_ID	NUMBER			site id of the supplier
SUPPLIER_CONTACT_ID	NUMBER			contact id of the supplier
INTERNAL_SUBMISSION_DATE	DATE			SDR submission date internal approval
ASIGNEE_RESPONSE_BY_DATE	DATE			Expected internal Response Date. Set at the time of creation of the SDR.(For internal approval purpose)
ASIGNEE_RESPONSE_DATE	DATE			Date responded.
SUBMTD_BY_FOR_SUPP_APPROVAL	NUMBER			SDR Request submitted for Supplier approval purpose.
SUPPLIER_RESPONSE_BY_DATE	DATE			Date at which the supplier has to respond to the SDR. Set at the time of creation of the SDR.
SUPPLIER_RESPONSE_DATE	DATE			Supplier responded date.
SUPPLIER_SUBMISSION_DATE	DATE			Date at which the distributor had submitted the SDR to supplier for approval.
REQUESTOR_ID	NUMBER		Yes	Requestor's resource id
SUPPLIER_QUOTE_NUMBER	VARCHAR2	(30)		Quote Number of the supplier.
INTERNAL_ORDER_NUMBER	NUMBER			Internal order number. This col shlould be used as qualifier.
SALES_ORDER_CURRENCY	VARCHAR2	(15)		Sales order currency code
REQUEST_SOURCE	VARCHAR2	(30)		Request Source
ASIGNEE_RESOURCE_ID	NUMBER			resource id to whom the request has been assigned
ORG_ID	NUMBER			Organization ID of the requestor (Distributor)
SECURITY_GROUP_ID	NUMBER			Std WHO col.
ACCRUAL_TYPE	VARCHAR2	(30)	Yes	Supplier/Internal
CUST_ACCOUNT_ID	NUMBER			Cost center info.
SUPPLIER_CONTACT_EMAIL_ADDRESS	VARCHAR2	(2000)		Email Address of supplier contact
SUPPLIER_CONTACT_PHONE_NUMBER	VARCHAR2	(60)		Phone number of supplier contact
REQUEST_TYPE_SETUP_ID	NUMBER			indicates the custom setup of Ship and Debit request
REQUEST_BASIS	VARCHAR2	(1)		flag indicates whether ship and debit request is request only or not
USER_STATUS_ID	NUMBER			id indicating the user status of the Ship and debit request
SUPPLIER_CONTACT_NAME	VARCHAR2	(360)		Name of the Supplier contact

Query Text

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


SELECT REQUEST_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
,      REQUEST_NUMBER
,      REQUEST_CLASS
,      OFFER_TYPE
,      OFFER_ID
,      ROOT_REQUEST_HEADER_ID
,      LINKED_REQUEST_HEADER_ID
,      REQUEST_START_DATE
,      REQUEST_END_DATE
,      REQUEST_OUTCOME
,      DECLINE_REASON_CODE
,      RETURN_REASON_CODE
,      REQUEST_CURRENCY_CODE
,      AUTHORIZATION_NUMBER
,      REQUESTED_BUDGET_AMOUNT
,      APPROVED_BUDGET_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_CONTACT_ID
,      INTERNAL_SUBMISSION_DATE
,      ASIGNEE_RESPONSE_BY_DATE
,      ASIGNEE_RESPONSE_DATE
,      SUBMTD_BY_FOR_SUPP_APPROVAL
,      SUPPLIER_RESPONSE_BY_DATE
,      SUPPLIER_RESPONSE_DATE
,      SUPPLIER_SUBMISSION_DATE
,      REQUESTOR_ID
,      SUPPLIER_QUOTE_NUMBER
,      INTERNAL_ORDER_NUMBER
,      SALES_ORDER_CURRENCY
,      REQUEST_SOURCE
,      ASIGNEE_RESOURCE_ID
,      ORG_ID
,      SECURITY_GROUP_ID
,      ACCRUAL_TYPE
,      CUST_ACCOUNT_ID
,      SUPPLIER_CONTACT_EMAIL_ADDRESS
,      SUPPLIER_CONTACT_PHONE_NUMBER
,      REQUEST_TYPE_SETUP_ID
,      REQUEST_BASIS
,      USER_STATUS_ID
,      SUPPLIER_CONTACT_NAME
FROM OZF.OZF_SD_REQUEST_HEADERS_ALL_B;

Dependencies

[top of page]

OZF.OZF_SD_REQUEST_HEADERS_ALL_B does not reference any database object

OZF.OZF_SD_REQUEST_HEADERS_ALL_B is referenced by following:

APPS: OZF_SD_REQUEST_HEADERS; OZF_SD_REQUEST_HEADERS_ALL_B