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: ViewPO.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

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

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:

SchemaAPPS
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES

APPS.PO_OWNED_REQUISITION_LINES is not referenced by any database object