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.POBV_REQUISITION_LINES

Object Details

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

View Type

A Business Intelligence System view

This shows item information for a good or service on a requisition.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
REQUISITION_ID	NUMBER		Yes
REQUISITION_DOCUMENT_NUMBER	VARCHAR2	(20)	Yes
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
_LA:REQUISITION_TYPE	CHAR	(72)
LINE_TYPE	VARCHAR2	(25)
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes
UNIT_PRICE	NUMBER
REQUESTED_QUANTITY	NUMBER
DELIVERED_QUANTITY	NUMBER
RECEIVED_QUANTITY	NUMBER
CANCELLED_QUANTITY	NUMBER
NEED_BY_DATE	DATE
_LA:DESTINATION_TYPE	CHAR	(77)
_LA:CANCEL_FLAG	CHAR	(57)
CANCEL_DATE	DATE
CANCEL_REASON	VARCHAR2	(240)
_LA:CLOSURE_STATUS	CHAR	(65)
CLOSED_DATE	DATE
CLOSED_REASON	VARCHAR2	(240)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_RATE_DATE	DATE
FOREIGN_CURRENCY_UNIT_PRICE	NUMBER
_LA:ENCUMBERED_FLAG	CHAR	(61)
JUSTIFICATION	VARCHAR2	(480)
_LA:MODIFIED_BY_BUYER_FLAG	CHAR	(68)
_LA:ON_RFQ_FLAG	CHAR	(57)
BUYER_NOTE	VARCHAR2	(480)
RECEIVER_NOTE	VARCHAR2	(480)
REFERENCE_NUMBER	VARCHAR2	(25)
_LA:RFQ_REQUIRED_FLAG	CHAR	(63)
_LA:SOURCE_DOCUMENT_TYPE	CHAR	(78)
_LA:REQUISITION_SOURCE_TYPE	CHAR	(79)
SUGGESTED_SUPPLIER	VARCHAR2	(240)
SUGGESTED_SUPPLIER_SITE	VARCHAR2	(240)
SUGGESTED_SUPPLIER_CONTACT	VARCHAR2	(80)
SUGGESTED_SUPPLIER_PHONE	VARCHAR2	(25)
SUGGESTED_VENDOR_CONTACT_FAX	VARCHAR2	(25)		Supplier fax information
SUGGESTED_VENDOR_CONTACT_EMAIL	VARCHAR2	(2000)		Supplier Email information
SUGGESTED_SUPPLIER_PRODUCT_NUM	VARCHAR2	(25)
SOURCE_SUBINVENTORY	VARCHAR2	(10)
TRANSACTION_REASON	VARCHAR2	(25)
_LA:URGENT_FLAG	CHAR	(57)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
DESTINATION_ORGANIZATION_ID	NUMBER
DESTINATION_SUBINVENTORY	VARCHAR2	(10)
HAZARD_CLASS_ID	NUMBER
UN_NUMBER_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_RATE_TYPE	VARCHAR2	(30)
DELIVER_TO_LOCATION_ID	NUMBER
DELIVER_TO_PERSON_ID	NUMBER	(9)	Yes
SUGGESTED_BUYER_ID	NUMBER	(9)
SOURCE_ORGANIZATION_ID	NUMBER
MODIFICATION_BUYER_ID	NUMBER	(9)
SOURCE_DOCUMENT_ID	NUMBER
SOURCE_DOCUMENT_LINE_NUMBER	NUMBER
SHIPMENT_ID	NUMBER
PARENT_REQUISITION_LINE_ID	NUMBER
BILL_OF_MATERIAL_RESOURCE_ID	NUMBER
WIP_ENTITY_ID	NUMBER
WIP_LINE_ID	NUMBER
WIP_REPETITIVE_SCHEDULE_ID	NUMBER
WIP_OPERATION_SEQUENCE_NUMBER	NUMBER
WIP_RESOURCE_SEQUENCE_NUMBER	NUMBER
CREATED_DATE	DATE
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SECONDARY_QUANTITY	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PREFERRED_GRADE	VARCHAR2	(150)
SECONDARY_QUANTITY_RECEIVED	NUMBER
SECONDARY_QUANTITY_CANCELLED	NUMBER
AUCTION_DISPLAY_NUMBER	VARCHAR2	(40)
AUCTION_HEADER_ID	NUMBER
AUCTION_LINE_NUMBER	NUMBER
BID_NUMBER	NUMBER
BID_LINE_NUMBER	NUMBER
_LA:REQS_IN_POOL_FLAG	CHAR	(63)
OKE_CONTRACT_HEADER_ID	NUMBER
OKE_CONTRACT_VERSION_ID	NUMBER
_LA:VMI_FLAG	CHAR	(54)
NOTE_TO_VENDOR	VARCHAR2	(480)
_LA:PCARD_FLAG	CHAR	(56)
_LA:TAX_USER_OVERRIDE_FLAG	CHAR	(68)
SHIP_METHOD	VARCHAR2	(30)		Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
ESTIMATED_PICKUP_DATE	DATE			Estimated pickup date.
SUPPLIER_NOTIFIED_FOR_CANCEL	VARCHAR2	(1)		Indicates whether a cancellation notification has been sent to the supplier for this requisition line.
BASE_UNIT_PRICE	NUMBER			Base Unit Price
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
DROP_SHIP_FLAG	VARCHAR2	(1)		Indicates whether the Shipment has a backing Sales Order Line.
AMOUNT	NUMBER			Amount on the req line
CURRENCY_AMOUNT	NUMBER			Foreign currency amount on the req line
LABOR_REQ_LINE_ID	NUMBER			Stored the referenced temp labor requisition line id for an expence line
JOB_ID	NUMBER			Reference to the HR Job
JOB_LONG_DESCRIPTION	VARCHAR2	(2000)		Job Detailed Description
CONTRACTOR_STATUS	VARCHAR2	(25)		Resource finalization status for temp labor req lines
CONTACT_INFORMATION	VARCHAR2	(240)		Job Contact Information
CANDIDATE_SCREENING_REQD_FLAG	VARCHAR2	(1)		Flag to indicate if candidate screening is required
CANDIDATE_FIRST_NAME	VARCHAR2	(240)		First Name of the Candidate
CANDIDATE_LAST_NAME	VARCHAR2	(240)		Last Name of the Candidate
ASSIGNMENT_END_DATE	DATE			End date for the candidate assignment
OVERTIME_ALLOWED_FLAG	VARCHAR2	(1)		Flag to indicate if overtime is allowed
CONTRACTOR_REQUISITION_FLAG	VARCHAR2	(1)		Indicates if the req is a temp labor req
ASSIGNMENT_START_DATE	DATE			Assignment start date for the candidate
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Value Basis of the line type
PURCHASE_BASIS	VARCHAR2	(30)	Yes	Purchase Basis of the line type
MATCHING_BASIS	VARCHAR2	(30)	Yes	Matching Basis of the line type
AT_SOURCING_FLAG	VARCHAR2	(1)		At Sourcing Flag

Query Text

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


SELECT REQUISITION_LINE_ID
,      LINE_NUMBER
,      REQUISITION_ID
,      REQUISITION_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:REQUISITION_TYPE
,      LINE_TYPE
,      ITEM_DESCRIPTION
,      UNIT_PRICE
,      REQUESTED_QUANTITY
,      DELIVERED_QUANTITY
,      RECEIVED_QUANTITY
,      CANCELLED_QUANTITY
,      NEED_BY_DATE
,      _LA:DESTINATION_TYPE
,      _LA:CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      _LA:CLOSURE_STATUS
,      CLOSED_DATE
,      CLOSED_REASON
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      FOREIGN_CURRENCY_UNIT_PRICE
,      _LA:ENCUMBERED_FLAG
,      JUSTIFICATION
,      _LA:MODIFIED_BY_BUYER_FLAG
,      _LA:ON_RFQ_FLAG
,      BUYER_NOTE
,      RECEIVER_NOTE
,      REFERENCE_NUMBER
,      _LA:RFQ_REQUIRED_FLAG
,      _LA:SOURCE_DOCUMENT_TYPE
,      _LA:REQUISITION_SOURCE_TYPE
,      SUGGESTED_SUPPLIER
,      SUGGESTED_SUPPLIER_SITE
,      SUGGESTED_SUPPLIER_CONTACT
,      SUGGESTED_SUPPLIER_PHONE
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      SUGGESTED_SUPPLIER_PRODUCT_NUM
,      SOURCE_SUBINVENTORY
,      TRANSACTION_REASON
,      _LA:URGENT_FLAG
,      USSGL_TRANSACTION_CODE
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      UNIT_OF_MEASURE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      HAZARD_CLASS_ID
,      UN_NUMBER_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE_TYPE
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      SUGGESTED_BUYER_ID
,      SOURCE_ORGANIZATION_ID
,      MODIFICATION_BUYER_ID
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_LINE_NUMBER
,      SHIPMENT_ID
,      PARENT_REQUISITION_LINE_ID
,      BILL_OF_MATERIAL_RESOURCE_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQUENCE_NUMBER
,      WIP_RESOURCE_SEQUENCE_NUMBER
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_CANCELLED
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      _LA:REQS_IN_POOL_FLAG
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      _LA:VMI_FLAG
,      NOTE_TO_VENDOR
,      _LA:PCARD_FLAG
,      _LA:TAX_USER_OVERRIDE_FLAG
,      SHIP_METHOD
,      ESTIMATED_PICKUP_DATE
,      SUPPLIER_NOTIFIED_FOR_CANCEL
,      BASE_UNIT_PRICE
,      NEGOTIATED_BY_PREPARER_FLAG
,      DROP_SHIP_FLAG
,      AMOUNT
,      CURRENCY_AMOUNT
,      LABOR_REQ_LINE_ID
,      JOB_ID
,      JOB_LONG_DESCRIPTION
,      CONTRACTOR_STATUS
,      CONTACT_INFORMATION
,      CANDIDATE_SCREENING_REQD_FLAG
,      CANDIDATE_FIRST_NAME
,      CANDIDATE_LAST_NAME
,      ASSIGNMENT_END_DATE
,      OVERTIME_ALLOWED_FLAG
,      CONTRACTOR_REQUISITION_FLAG
,      ASSIGNMENT_START_DATE
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      AT_SOURCING_FLAG
FROM APPS.POBV_REQUISITION_LINES;

Dependencies

[top of page]

APPS.POBV_REQUISITION_LINES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; PO_LINE_TYPES; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL

APPS.POBV_REQUISITION_LINES is not referenced by any database object