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]

TYPE: APPS.POS_CHG_REC

Object Details

Object Name:	POS_CHG_REC
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ACTION_TYPE	VARCHAR2	(30)
INITIATOR	VARCHAR2	(30)
REQUEST_REASON	VARCHAR2	(2000)
DOCUMENT_TYPE	VARCHAR2	(30)
REQUEST_LEVEL	VARCHAR2	(30)
REQUEST_STATUS	VARCHAR2	(30)
DOCUMENT_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER
DOCUMENT_NUM	VARCHAR2	(20)
DOCUMENT_REVISION_NUM	NUMBER
DOCUMENT_LINE_ID	NUMBER
DOCUMENT_LINE_NUMBER	NUMBER
DOCUMENT_LINE_LOCATION_ID	NUMBER
DOCUMENT_SHIPMENT_NUMBER	NUMBER
DOCUMENT_DISTRIBUTION_ID	NUMBER
DOCUMENT_DISTRIBUTION_NUMBER	NUMBER
PARENT_LINE_LOCATION_ID	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_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)
NEW_SUPPLIER_REFERENCE_NUMBER	VARCHAR2	(30)
FROM_HEADER_ID	NUMBER
RECOVERABLE_TAX	NUMBER
NON_RECOVERABLE_TAX	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_ORGANIZATION_ID	NUMBER
OLD_NEED_BY_DATE	DATE
NEW_NEED_BY_DATE	DATE
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
PARENT_CHANGE_REQUEST_ID	NUMBER
REQUESTER_ID	NUMBER
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)
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
SUPPLIER_DOC_REF	VARCHAR2	(256)
SUPPLIER_LINE_REF	VARCHAR2	(256)
SUPPLIER_SHIPMENT_REF	VARCHAR2	(256)
NEW_PROGRESS_TYPE	VARCHAR2	(25)
NEW_PAY_DESCRIPTION	VARCHAR2	(100)

Dependencies

[top of page]

APPS.POS_CHG_REC references the following:

SYS: STANDARD - show dependent code

APPS.POS_CHG_REC is referenced by following:

APPS: POS_CHG_REC_TBL; PO_CHG_REQUEST_GRP - show dependent code; PO_CHG_REQUEST_PVT - show dependent code; PO_CHG_REQUEST_PVT - show dependent code; PO_RCO_VALIDATION_PVT - show dependent code; PO_REQCHANGEREQUESTWF_PVT - show dependent code