View: POBV_REQUISITION_LINES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_REQUISITION_LINES

View Text

SELECT RL.REQUISITION_LINE_ID
, RL.LINE_NUM
, RL.REQUISITION_HEADER_ID
, RH.SEGMENT1
, RL.ORG_ID
, OP.NAME
, '_LA:RH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:REQUISITION TYPE:DISPLAYED_FIELD'
, LT.LINE_TYPE
, RL.ITEM_DESCRIPTION
, RL.UNIT_PRICE
, RL.QUANTITY
, RL.QUANTITY_DELIVERED
, RL.QUANTITY_RECEIVED
, RL.QUANTITY_CANCELLED
, RL.NEED_BY_DATE
, '_LA:RL.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DISPLAYED_FIELD'
, '_LA:RL.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.CANCEL_DATE
, RL.CANCEL_REASON
, '_LA:RL.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, RL.CLOSED_DATE
, RL.CLOSED_REASON
, RL.RATE
, RL.RATE_DATE
, RL.CURRENCY_UNIT_PRICE
, '_LA:RL.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.JUSTIFICATION
, '_LA:RL.MODIFIED_BY_AGENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.ON_RFQ_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.NOTE_TO_AGENT
, RL.NOTE_TO_RECEIVER
, RL.REFERENCE_NUM
, '_LA:RL.RFQ_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:SOURCE DOCUMENT TYPE:DISPLAYED_FIELD'
, '_LA:RL.SOURCE_TYPE_CODE:PO_LOOKUP_CODES:REQUISITION SOURCE TYPE:DISPLAYED_FIELD'
, RL.SUGGESTED_VENDOR_NAME
, RL.SUGGESTED_VENDOR_LOCATION
, RL.SUGGESTED_VENDOR_CONTACT
, RL.SUGGESTED_VENDOR_PHONE
, RL.SUGGESTED_VENDOR_CONTACT_FAX
, RL.SUGGESTED_VENDOR_CONTACT_EMAIL
, RL.SUGGESTED_VENDOR_PRODUCT_CODE
, RL.SOURCE_SUBINVENTORY
, RL.TRANSACTION_REASON_CODE
, '_LA:RL.URGENT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.USSGL_TRANSACTION_CODE
, RL.ITEM_ID
, RL.ITEM_REVISION
, RL.CATEGORY_ID
, RL.UNIT_MEAS_LOOKUP_CODE
, RL.DESTINATION_ORGANIZATION_ID
, RL.DESTINATION_SUBINVENTORY
, RL.HAZARD_CLASS_ID
, RL.UN_NUMBER_ID
, RL.CURRENCY_CODE
, RL.RATE_TYPE
, RL.DELIVER_TO_LOCATION_ID
, RL.TO_PERSON_ID
, RL.SUGGESTED_BUYER_ID
, RL.SOURCE_ORGANIZATION_ID
, RL.PURCHASING_AGENT_ID
, RL.BLANKET_PO_HEADER_ID
, RL.BLANKET_PO_LINE_NUM
, RL.LINE_LOCATION_ID
, RL.PARENT_REQ_LINE_ID
, RL.BOM_RESOURCE_ID
, RL.WIP_ENTITY_ID
, RL.WIP_LINE_ID
, RL.WIP_REPETITIVE_SCHEDULE_ID
, RL.WIP_OPERATION_SEQ_NUM
, RL.WIP_RESOURCE_SEQ_NUM
, RL.CREATION_DATE
, RL.CREATED_BY
, RL.LAST_UPDATE_DATE
, RL.LAST_UPDATED_BY
, RL.SECONDARY_QUANTITY
, RL.SECONDARY_UNIT_OF_MEASURE
, RL.PREFERRED_GRADE
, RL.SECONDARY_QUANTITY_RECEIVED
, RL.SECONDARY_QUANTITY_CANCELLED
, RL.AUCTION_DISPLAY_NUMBER
, RL.AUCTION_HEADER_ID
, RL.AUCTION_LINE_NUMBER
, RL.BID_NUMBER
, RL.BID_LINE_NUMBER
, '_LA:RL.REQS_IN_POOL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.OKE_CONTRACT_HEADER_ID
, RL.OKE_CONTRACT_VERSION_ID
, '_LA:RL.VMI_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.NOTE_TO_VENDOR
, '_LA:RL.PCARD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:RL.TAX_USER_OVERRIDE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RL.SHIP_METHOD
, RL.ESTIMATED_PICKUP_DATE
, RL.SUPPLIER_NOTIFIED_FOR_CANCEL
, RL.BASE_UNIT_PRICE
, RL.NEGOTIATED_BY_PREPARER_FLAG
, RL.DROP_SHIP_FLAG
, RL.AMOUNT
, RL.CURRENCY_AMOUNT
, RL.LABOR_REQ_LINE_ID
, RL.JOB_ID
, RL.JOB_LONG_DESCRIPTION
, RL.CONTRACTOR_STATUS
, RL.CONTACT_INFORMATION
, RL.CANDIDATE_SCREENING_REQD_FLAG
, RL.CANDIDATE_FIRST_NAME
, RL.CANDIDATE_LAST_NAME
, RL.ASSIGNMENT_END_DATE
, RL.OVERTIME_ALLOWED_FLAG
, RL.CONTRACTOR_REQUISITION_FLAG
, RL.ASSIGNMENT_START_DATE
, RL.ORDER_TYPE_LOOKUP_CODE
, RL.PURCHASE_BASIS
, RL.MATCHING_BASIS
FROM PO_REQUISITION_LINES_ALL RL
, PO_REQUISITION_HEADERS_ALL RH
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID
AND RL.ORG_ID = OP.ORGANIZATION_ID
AND RL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND '_SEC:RL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns