VIEW: APPS.POBV_REQUISITION_LINES

Source

View Text - Preformatted

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, RL.AT_SOURCING_FLAG 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(+) WITH READ ONLY

View Text - HTML Formatted

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
, RL.AT_SOURCING_FLAG
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(+) WITH READ ONLY