[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PO.PO_CHANGE_REQUESTS does not reference any database object
PO.PO_CHANGE_REQUESTS is referenced by following:
|
|
|