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_BATCH_HEADERS_ALL

Object Details

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

OZF_SD_BATCH_HEADERS_ALL stores the header information of Supplier Ship and Debit Batch in Oracle Trade Management

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_SD_BATCH_HEADERS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
OZF_SD_BATCH_HEADERS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_NUMBER
OZF_SD_BATCH_HEADERS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
OZF_SD_BATCH_HEADERS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Batch Identifier
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control when using HTML as a user interface
BATCH_NUMBER	VARCHAR2	(30)	Yes	Unique number for Batch, system generated by sequence OZF_SD_BATCH_HEADERS_ALL_S
CHILD_BATCH_ID	NUMBER			Reference to child batch
BATCH_SUBMISSION_DATE	DATE			Data on which the batch was last submitted
CLAIM_ID	NUMBER			Reference to claim
VENDOR_ID	NUMBER		Yes	Reference to Supplier
VENDOR_SITE_ID	NUMBER		Yes	Reference to Supplier Site
VENDOR_CONTACT_ID	NUMBER			Reference to Supplier Contact
VENDOR_EMAIL	VARCHAR2	(2000)		Supplier contact email
VENDOR_PHONE	VARCHAR2	(60)		Supplier contact phone
VENDOR_FAX	VARCHAR2	(60)		Supplier contact fax
BATCH_LINE_AMOUNT_THRESHOLD	NUMBER			Line threshold as set in supplier trade profile at the time of batch creation
BATCH_AMOUNT_THRESHOLD	NUMBER			Trade Profile threshold for batch amount
CURRENCY_CODE	VARCHAR2	(15)		Batch Currency
CREDIT_CODE	VARCHAR2	(1)		Credit 'C' / Debit 'D' identifier
STATUS_CODE	VARCHAR2	(30)		Batch Status
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
REQUEST_ID	NUMBER			Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATED_FROM	VARCHAR2	(30)		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
TRANSFER_TYPE	VARCHAR2	(30)		Specifies the mode of transmission. Either XML or WebADI
ORG_ID	NUMBER			Organization identifier
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
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
CLAIM_NUMBER	VARCHAR2	(30)		Claim Number
VENDOR_CREDIT_REF	VARCHAR2	(30)		Vendor Credit reference
PARENT_BATCH_ID	NUMBER			Reference for parent batch
CLAIM_MINOR_VERSION	NUMBER			Stores minor version of claim
VENDOR_CONTACT_NAME	VARCHAR2	(360)		Name of the vendor contact
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield segment
BATCH_TYPE	VARCHAR2	(30)		Indicates the type of batch
OWNER_ID	NUMBER			Owner Id of the Batch
IMD_CLAIM_FLAG	VARCHAR2	(1)		Indicates whether partial approved amout of line can be claimed

Query Text

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


SELECT BATCH_ID
,      OBJECT_VERSION_NUMBER
,      BATCH_NUMBER
,      CHILD_BATCH_ID
,      BATCH_SUBMISSION_DATE
,      CLAIM_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      VENDOR_EMAIL
,      VENDOR_PHONE
,      VENDOR_FAX
,      BATCH_LINE_AMOUNT_THRESHOLD
,      BATCH_AMOUNT_THRESHOLD
,      CURRENCY_CODE
,      CREDIT_CODE
,      STATUS_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      CREATED_BY
,      CREATED_FROM
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      TRANSFER_TYPE
,      ORG_ID
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLAIM_NUMBER
,      VENDOR_CREDIT_REF
,      PARENT_BATCH_ID
,      CLAIM_MINOR_VERSION
,      VENDOR_CONTACT_NAME
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      BATCH_TYPE
,      OWNER_ID
,      IMD_CLAIM_FLAG
FROM OZF.OZF_SD_BATCH_HEADERS_ALL;

Dependencies

[top of page]

OZF.OZF_SD_BATCH_HEADERS_ALL does not reference any database object

OZF.OZF_SD_BATCH_HEADERS_ALL is referenced by following:

OZF: OZF_SD_BATCH_HEADERS_ALL#