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

Object Details

Object Name:	PO_CHANGE_REQUESTS#
Object Type:	VIEW
Owner:	PO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CHANGE_REQUEST_GROUP_ID	NUMBER		Yes
CHANGE_REQUEST_ID	NUMBER		Yes
INITIATOR	VARCHAR2	(30)	Yes
ACTION_TYPE	VARCHAR2	(30)	Yes
REQUEST_REASON	VARCHAR2	(2000)
REQUEST_LEVEL	VARCHAR2	(30)	Yes
REQUEST_STATUS	VARCHAR2	(30)	Yes
DOCUMENT_TYPE	VARCHAR2	(30)	Yes
DOCUMENT_HEADER_ID	NUMBER		Yes
DOCUMENT_NUM	VARCHAR2	(20)
DOCUMENT_REVISION_NUM	NUMBER
PO_RELEASE_ID	NUMBER
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER		Yes
DOCUMENT_LINE_ID	NUMBER
DOCUMENT_LINE_NUMBER	NUMBER
DOCUMENT_LINE_LOCATION_ID	NUMBER
DOCUMENT_SHIPMENT_NUMBER	NUMBER
PARENT_LINE_LOCATION_ID	NUMBER
DOCUMENT_DISTRIBUTION_ID	NUMBER
DOCUMENT_DISTRIBUTION_NUMBER	NUMBER
OLD_QUANTITY	NUMBER
NEW_QUANTITY	NUMBER
OLD_PROMISED_DATE	DATE
NEW_PROMISED_DATE	DATE
OLD_SUPPLIER_PART_NUMBER	VARCHAR2	(25)
NEW_SUPPLIER_PART_NUMBER	VARCHAR2	(25)
OLD_PRICE	NUMBER
NEW_PRICE	NUMBER
OLD_NEED_BY_DATE	DATE
NEW_NEED_BY_DATE	DATE
OLD_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)
NEW_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)
REQUESTER_ID	NUMBER
RESPONDED_BY	NUMBER
RESPONSE_DATE	DATE
RESPONSE_REASON	VARCHAR2	(2000)
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
VENDOR_CONTACT_ID	NUMBER
REQUEST_EXPIRATION_DATE	DATE
OLD_CURRENCY_UNIT_PRICE	NUMBER
NEW_CURRENCY_UNIT_PRICE	NUMBER
RECOVERABLE_TAX	NUMBER
NONRECOVERABLE_TAX	NUMBER
WF_ITEM_TYPE	VARCHAR2	(8)
WF_ITEM_KEY	VARCHAR2	(240)
PARENT_CHANGE_REQUEST_ID	NUMBER
VALIDATION_ERROR	VARCHAR2	(2000)
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
OLD_SUPPLIER_ORDER_NUMBER	VARCHAR2	(25)
NEW_SUPPLIER_ORDER_NUMBER	VARCHAR2	(25)
OLD_SUPPLIER_ORDER_LINE_NUMBER	VARCHAR2	(25)
NEW_SUPPLIER_ORDER_LINE_NUMBER	VARCHAR2	(25)
CHANGE_ACTIVE_FLAG	VARCHAR2	(1)
CANCEL_BACKING_REQ	VARCHAR2	(1)
REF_PO_NUM	VARCHAR2	(20)
REF_PO_HEADER_ID	NUMBER
REF_PO_RELEASE_ID	NUMBER
REF_PO_REL_NUM	NUMBER
MSG_CONT_NUM	NUMBER
REQUEST_ORIGIN	VARCHAR2	(10)
ADDITIONAL_CHANGES	VARCHAR2	(2000)
OLD_START_DATE	DATE
NEW_START_DATE	DATE
OLD_EXPIRATION_DATE	DATE
NEW_EXPIRATION_DATE	DATE
OLD_AMOUNT	NUMBER
NEW_AMOUNT	NUMBER
OLD_CURRENCY_AMOUNT	NUMBER
NEW_CURRENCY_AMOUNT	NUMBER
SUPPLIER_DOC_REF	VARCHAR2	(256)
SUPPLIER_LINE_REF	VARCHAR2	(256)
SUPPLIER_SHIPMENT_REF	VARCHAR2	(256)
NEW_PROGRESS_TYPE	VARCHAR2	(30)
NEW_PAY_DESCRIPTION	VARCHAR2	(240)

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# references the following:

PO: PO_CHANGE_REQUESTS

PO.PO_CHANGE_REQUESTS# is referenced by following:

APPS: PO_CHANGE_REQUESTS