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: APPS.PO_OWNED_REQUISITION_LINES

Object Details

Object Name:	PO_OWNED_REQUISITION_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_OWNED_REQUISITION_LINES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition header unique identifier
LINE_NUM	NUMBER		Yes	Line number
LINE_TYPE_ID	NUMBER		Yes	Line type (New in Version 7.0)
CATEGORY_ID	NUMBER		Yes	Item category unique identifier
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes	Item description
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure
UNIT_PRICE	NUMBER			Unit price in functional currency
QUANTITY	NUMBER			Quantity ordered
DELIVER_TO_LOCATION_ID	NUMBER		Yes	Deliver-to location unique identifier
TO_PERSON_ID	NUMBER	(9)	Yes	Requestor unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SOURCE_TYPE_CODE	VARCHAR2	(25)	Yes	Requisition source type of item
OWNER_ID	NUMBER	(9)	Yes	Unique identifier of the employee who prepared the requisition
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ITEM_ID	NUMBER			Item unique identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision (New in Version 7.0)
QUANTITY_DELIVERED	NUMBER			Quantity delivered to date
SUGGESTED_BUYER_ID	NUMBER	(9)		Suggested buyer unique identifier
ENCUMBERED_FLAG	VARCHAR2	(1)		Indicates whether the distribution is encumbered
RFQ_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether an RFQ is required prior to placement on a purchase order
NEED_BY_DATE	DATE			Date the requisition is needed internally
LINE_LOCATION_ID	NUMBER			Document shipment schedule unique identifier
MODIFIED_BY_AGENT_FLAG	VARCHAR2	(1)		Indicates whether a buyer modified this line or not
PARENT_REQ_LINE_ID	NUMBER			Unique identifier of the parent requisition line for a modified requisition
JUSTIFICATION	VARCHAR2	(480)		Purchase justification
NOTE_TO_AGENT	VARCHAR2	(480)		Note to buyer
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to deliverer
PURCHASING_AGENT_ID	NUMBER	(9)		Unique identifier of the buyer who modified the requisition line
BLANKET_PO_HEADER_ID	NUMBER			Suggested source blanket agreement or catalog quotation header unqiue identifier
BLANKET_PO_LINE_NUM	NUMBER			Suggested source blanket agreement or catalog quotation line number
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vendor name
SUGGESTED_VENDOR_LOCATION	VARCHAR2	(240)		Suggested vendor site name
SUGGESTED_VENDOR_CONTACT	VARCHAR2	(80)		Suggested vendor contact name
SUGGESTED_VENDOR_PHONE	VARCHAR2	(25)		Suggested vendor phone number
SUGGESTED_VENDOR_PRODUCT_CODE	VARCHAR2	(25)		Suggested vendor product number
UN_NUMBER_ID	NUMBER			Un number unique identifier (New in Version 7.0)
HAZARD_CLASS_ID	NUMBER			Hazard class unique identifier
MUST_USE_SUGG_VENDOR_FLAG	VARCHAR2	(1)		Unused since Version 8.0
REFERENCE_NUM	VARCHAR2	(25)		Reference number
ON_RFQ_FLAG	VARCHAR2	(1)		Indicates whether the requisition line was placed on a RFQ
URGENT_FLAG	VARCHAR2	(1)		Indicates whether the requisition is urgent or not
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the requisition is cancelled or not
SOURCE_ORGANIZATION_ID	NUMBER			Inventory source organization unique identifier
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Inventory source subinventory name
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type
DESTINATION_ORGANIZATION_ID	NUMBER			Destination organization unique identifier
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Destination Subinventory name
QUANTITY_CANCELLED	NUMBER			Quantity cancelled
CANCEL_DATE	DATE			Cancel date
CANCEL_REASON	VARCHAR2	(240)		Cancel reason
CLOSED_CODE	VARCHAR2	(25)		Close Status
AGENT_RETURN_NOTE	VARCHAR2	(480)		Unused since Version 7.0
CHANGED_AFTER_RESEARCH_FLAG	VARCHAR2	(1)		Unused since Version 7.0
VENDOR_ID	NUMBER			Vendor unique identifier
VENDOR_SITE_ID	NUMBER			Vendor site unique identifier
VENDOR_CONTACT_ID	NUMBER			Vendor contact unique identifier
RESEARCH_AGENT_ID	NUMBER	(9)		Unused since version 7.0
ON_LINE_FLAG	VARCHAR2	(1)		Unused since Version 7.0
WIP_ENTITY_ID	NUMBER			WIP job or repetitive assembly identifier
WIP_LINE_ID	NUMBER			WIP line identifier
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule identifier
WIP_OPERATION_SEQ_NUM	NUMBER			WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM	NUMBER			WIP resource sequence number
BOM_RESOURCE_ID	NUMBER			BOM resource unique identifier
DESTINATION_CONTEXT	VARCHAR2	(30)		Destination descriptive flexfield context column
INVENTORY_SOURCE_CONTEXT	VARCHAR2	(30)		Inventory source descriptive flexfield context column
VENDOR_SOURCE_CONTEXT	VARCHAR2	(30)		Vendor source descriptive flexfield context column
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition 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
ORG_ID	NUMBER			Organization identifier

Query Text

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


SELECT REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      QUANTITY
,      DELIVER_TO_LOCATION_ID
,      TO_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SOURCE_TYPE_CODE
,      OWNER_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ITEM_ID
,      ITEM_REVISION
,      QUANTITY_DELIVERED
,      SUGGESTED_BUYER_ID
,      ENCUMBERED_FLAG
,      RFQ_REQUIRED_FLAG
,      NEED_BY_DATE
,      LINE_LOCATION_ID
,      MODIFIED_BY_AGENT_FLAG
,      PARENT_REQ_LINE_ID
,      JUSTIFICATION
,      NOTE_TO_AGENT
,      NOTE_TO_RECEIVER
,      PURCHASING_AGENT_ID
,      BLANKET_PO_HEADER_ID
,      BLANKET_PO_LINE_NUM
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_LOCATION
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      UN_NUMBER_ID
,      HAZARD_CLASS_ID
,      MUST_USE_SUGG_VENDOR_FLAG
,      REFERENCE_NUM
,      ON_RFQ_FLAG
,      URGENT_FLAG
,      CANCEL_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      QUANTITY_CANCELLED
,      CANCEL_DATE
,      CANCEL_REASON
,      CLOSED_CODE
,      AGENT_RETURN_NOTE
,      CHANGED_AFTER_RESEARCH_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      RESEARCH_AGENT_ID
,      ON_LINE_FLAG
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      DESTINATION_CONTEXT
,      INVENTORY_SOURCE_CONTEXT
,      VENDOR_SOURCE_CONTEXT
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
FROM APPS.PO_OWNED_REQUISITION_LINES;

Dependencies

[top of page]

APPS.PO_OWNED_REQUISITION_LINES references the following:

APPS: PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES

APPS.PO_OWNED_REQUISITION_LINES is not referenced by any database object