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: PO.PO_CHANGE_REQUESTS

Object Details

Object Name:	PO_CHANGE_REQUESTS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_CHANGE_REQUESTS
Subobject Name:
Status:	VALID

PO_CHANGE_REQUEST table stores the change requests submitted on Purchase Orders, Releases or Requisitions by Suppliers or Requesters

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_CHANGE_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGE_REQUEST_ID
PO_CHANGE_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADER_ID
PO_CHANGE_REQUESTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_LINE_ID
PO_CHANGE_REQUESTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_REQUEST_GROUP_ID
PO_CHANGE_REQUESTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_STATUS REQUEST_LEVEL

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGE_REQUEST_GROUP_ID	NUMBER		Yes	Group Id for all change requests submitted together on a Purchase Order at a given time
CHANGE_REQUEST_ID	NUMBER		Yes	Unique key for the table to identify each individual change requests
INITIATOR	VARCHAR2	(30)	Yes	The source of change request. Possible values are "SUPPLIER" / "REQUESTER"
ACTION_TYPE	VARCHAR2	(30)	Yes	Type of action requested. Possible values are "MODIFICATION" / "CANCELLATION"
REQUEST_REASON	VARCHAR2	(2000)		Reason for submitting the change request
REQUEST_LEVEL	VARCHAR2	(30)	Yes	Level at which the change is requested. Possible values are "HEADER" / "LINE" / "SHIPMENT" / "DISTRIBUTION"
REQUEST_STATUS	VARCHAR2	(30)	Yes	Processing status of the change request. Possible values are "PENDING" / "ACCEPTED" / "REJECTED" and other internal statuses
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	The type of document i.e. purchase order, release or requisition
DOCUMENT_HEADER_ID	NUMBER		Yes	PO Header Id or the Requisition Id
DOCUMENT_NUM	VARCHAR2	(20)		PO (and Release) Number, or Requisition Number
DOCUMENT_REVISION_NUM	NUMBER			Document Revision Number
PO_RELEASE_ID	NUMBER			PO Release Id
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DOCUMENT_LINE_ID	NUMBER			Document Line Id
DOCUMENT_LINE_NUMBER	NUMBER			Document Line Number
DOCUMENT_LINE_LOCATION_ID	NUMBER			Document Line Location Id
DOCUMENT_SHIPMENT_NUMBER	NUMBER			Document Shipment Number
PARENT_LINE_LOCATION_ID	NUMBER			Line location Id of parent shipment on which the split request was made
DOCUMENT_DISTRIBUTION_ID	NUMBER			Document distribution id
DOCUMENT_DISTRIBUTION_NUMBER	NUMBER			Document distribution number
OLD_QUANTITY	NUMBER			Original Quantity
NEW_QUANTITY	NUMBER			New quantity requested
OLD_PROMISED_DATE	DATE			Original Promise Date
NEW_PROMISED_DATE	DATE			New Promise Date requested
OLD_SUPPLIER_PART_NUMBER	VARCHAR2	(25)		Original Supplier Item Number
NEW_SUPPLIER_PART_NUMBER	VARCHAR2	(25)		New Supplier Item Number
OLD_PRICE	NUMBER			Original Price
NEW_PRICE	NUMBER			New Price requested
OLD_NEED_BY_DATE	DATE			Original need-by date
NEW_NEED_BY_DATE	DATE			New need-by date requested
OLD_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)		Old Supplier Reference Number
NEW_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)		New supplier reference number
REQUESTER_ID	NUMBER			Id of person submitting the requisition change
RESPONDED_BY	NUMBER			Id of person responding to change request
RESPONSE_DATE	DATE			Date of response
RESPONSE_REASON	VARCHAR2	(2000)		Reason given in response to change request
VENDOR_ID	NUMBER			Vendor Id
VENDOR_SITE_ID	NUMBER			Vendor Site Id
VENDOR_CONTACT_ID	NUMBER			Vendor Contact Id
REQUEST_EXPIRATION_DATE	DATE			Field Not used
OLD_CURRENCY_UNIT_PRICE	NUMBER			Old Currency Unit Price
NEW_CURRENCY_UNIT_PRICE	NUMBER			New Currency Unit Price
RECOVERABLE_TAX	NUMBER			Recoverable Tax
NONRECOVERABLE_TAX	NUMBER			Non Recoverable tax
WF_ITEM_TYPE	VARCHAR2	(8)		Workflow Item Type
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Item Key
PARENT_CHANGE_REQUEST_ID	NUMBER			Change Request Id of requisition change from which the PO Change Request is derived
VALIDATION_ERROR	VARCHAR2	(2000)		Validation Error while processing the change request
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)		Approval Required Flag
OLD_SUPPLIER_ORDER_NUMBER	VARCHAR2	(25)		Original Sales Order Number
NEW_SUPPLIER_ORDER_NUMBER	VARCHAR2	(25)		New Sales Order Number
OLD_SUPPLIER_ORDER_LINE_NUMBER	VARCHAR2	(25)		Original Sales Order Line Number
NEW_SUPPLIER_ORDER_LINE_NUMBER	VARCHAR2	(25)		New Sales Order Line Number
CHANGE_ACTIVE_FLAG	VARCHAR2	(1)		Change Active Flag
CANCEL_BACKING_REQ	VARCHAR2	(1)		Flag to Indicate whether associated Requisition is to be cancelled for Cancel Shipment Requests
REF_PO_NUM	VARCHAR2	(20)		Reference PO Number
REF_PO_HEADER_ID	NUMBER			Reference PO Header Id
REF_PO_RELEASE_ID	NUMBER			Reference PO Release Id
REF_PO_REL_NUM	NUMBER			Reference PO Release Number
MSG_CONT_NUM	NUMBER			Internal Control Number generated in XML Gateway
REQUEST_ORIGIN	VARCHAR2	(10)		Origin of the Request. Currently, standard values are:XML/OTA/9iAS/EDI/UI/null
ADDITIONAL_CHANGES	VARCHAR2	(2000)		Additional Changes
OLD_START_DATE	DATE			Original Start Date
NEW_START_DATE	DATE			New Start Date
OLD_EXPIRATION_DATE	DATE			Original End Date
NEW_EXPIRATION_DATE	DATE			New End Date
OLD_AMOUNT	NUMBER			Amount value before change
NEW_AMOUNT	NUMBER			Amount value after change
OLD_CURRENCY_AMOUNT	NUMBER			Currency Amount Value before change
NEW_CURRENCY_AMOUNT	NUMBER			Currency Amount value after change
SUPPLIER_DOC_REF	VARCHAR2	(256)		Supplier system document reference for this change request.
SUPPLIER_LINE_REF	VARCHAR2	(256)		Supplier system line reference for this change request.
SUPPLIER_SHIPMENT_REF	VARCHAR2	(256)		Supplier system shipment reference for this change request.
NEW_PROGRESS_TYPE	VARCHAR2	(30)		This attribute stores the Progress Type change at the pay item level
NEW_PAY_DESCRIPTION	VARCHAR2	(240)		This attribute stores the pay item description change at the pay item level

Query Text

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


SELECT CHANGE_REQUEST_GROUP_ID
,      CHANGE_REQUEST_ID
,      INITIATOR
,      ACTION_TYPE
,      REQUEST_REASON
,      REQUEST_LEVEL
,      REQUEST_STATUS
,      DOCUMENT_TYPE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_NUM
,      DOCUMENT_REVISION_NUM
,      PO_RELEASE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DOCUMENT_LINE_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_LINE_LOCATION_ID
,      DOCUMENT_SHIPMENT_NUMBER
,      PARENT_LINE_LOCATION_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_DISTRIBUTION_NUMBER
,      OLD_QUANTITY
,      NEW_QUANTITY
,      OLD_PROMISED_DATE
,      NEW_PROMISED_DATE
,      OLD_SUPPLIER_PART_NUMBER
,      NEW_SUPPLIER_PART_NUMBER
,      OLD_PRICE
,      NEW_PRICE
,      OLD_NEED_BY_DATE
,      NEW_NEED_BY_DATE
,      OLD_SUPPLIER_REFERENCE_NUMBER
,      NEW_SUPPLIER_REFERENCE_NUMBER
,      REQUESTER_ID
,      RESPONDED_BY
,      RESPONSE_DATE
,      RESPONSE_REASON
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      REQUEST_EXPIRATION_DATE
,      OLD_CURRENCY_UNIT_PRICE
,      NEW_CURRENCY_UNIT_PRICE
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PARENT_CHANGE_REQUEST_ID
,      VALIDATION_ERROR
,      APPROVAL_REQUIRED_FLAG
,      OLD_SUPPLIER_ORDER_NUMBER
,      NEW_SUPPLIER_ORDER_NUMBER
,      OLD_SUPPLIER_ORDER_LINE_NUMBER
,      NEW_SUPPLIER_ORDER_LINE_NUMBER
,      CHANGE_ACTIVE_FLAG
,      CANCEL_BACKING_REQ
,      REF_PO_NUM
,      REF_PO_HEADER_ID
,      REF_PO_RELEASE_ID
,      REF_PO_REL_NUM
,      MSG_CONT_NUM
,      REQUEST_ORIGIN
,      ADDITIONAL_CHANGES
,      OLD_START_DATE
,      NEW_START_DATE
,      OLD_EXPIRATION_DATE
,      NEW_EXPIRATION_DATE
,      OLD_AMOUNT
,      NEW_AMOUNT
,      OLD_CURRENCY_AMOUNT
,      NEW_CURRENCY_AMOUNT
,      SUPPLIER_DOC_REF
,      SUPPLIER_LINE_REF
,      SUPPLIER_SHIPMENT_REF
,      NEW_PROGRESS_TYPE
,      NEW_PAY_DESCRIPTION
FROM PO.PO_CHANGE_REQUESTS;

Dependencies

[top of page]

PO.PO_CHANGE_REQUESTS does not reference any database object

PO.PO_CHANGE_REQUESTS is referenced by following:

PO: PO_CHANGE_REQUESTS#