Product: | PO - Purchasing |
---|---|
Description: | Requisition Lines View. |
Implementation/DBA Data: | APPS.PO_REQ_LINES_TRX_V |
SELECT PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_HEADER_ID
, NVL(PRL.LINE_NUM_DISPLAY
, TO_CHAR(PRL.LINE_NUM)) LINE_NUM
, PRL.LINE_TYPE_ID
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.QUANTITY
, PRL.DELIVER_TO_LOCATION_ID
, PRL.TO_PERSON_ID
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATED_BY
, PRL.SOURCE_TYPE_CODE
, PRL.LAST_UPDATE_LOGIN
, PRL.CREATION_DATE
, PRL.CREATED_BY
, PRL.ITEM_ID
, PRL.ITEM_REVISION
, PRL.QUANTITY_DELIVERED
, PRL.SUGGESTED_BUYER_ID
, PRL.ENCUMBERED_FLAG
, PRL.RFQ_REQUIRED_FLAG
, PRL.NEED_BY_DATE
, PRL.LINE_LOCATION_ID
, PRL.MODIFIED_BY_AGENT_FLAG
, PRL.PARENT_REQ_LINE_ID
, PRL.JUSTIFICATION
, PRL.NOTE_TO_AGENT
, PRL.NOTE_TO_RECEIVER
, PRL.PURCHASING_AGENT_ID
, PRL.DOCUMENT_TYPE_CODE
, PRL.BLANKET_PO_HEADER_ID
, PRL.BLANKET_PO_LINE_NUM
, PRL.CURRENCY_CODE
, PRL.RATE_TYPE
, PRL.RATE_DATE
, PRL.RATE
, PRL.CURRENCY_UNIT_PRICE
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.SUGGESTED_VENDOR_CONTACT
, PRL.SUGGESTED_VENDOR_PHONE
, PRL.SUGGESTED_VENDOR_PRODUCT_CODE
, PRL.UN_NUMBER_ID
, PRL.HAZARD_CLASS_ID
, PRL.MUST_USE_SUGG_VENDOR_FLAG
, PRL.REFERENCE_NUM
, PRL.ON_RFQ_FLAG
, PRL.URGENT_FLAG
, PRL.CANCEL_FLAG
, PRL.SOURCE_ORGANIZATION_ID
, PRL.SOURCE_SUBINVENTORY
, PRL.DESTINATION_TYPE_CODE
, PRL.DESTINATION_ORGANIZATION_ID
, PRL.DESTINATION_SUBINVENTORY
, PRL.QUANTITY_CANCELLED
, PRL.CANCEL_DATE
, PRL.CANCEL_REASON
, PRL.CLOSED_CODE
, PRL.AGENT_RETURN_NOTE
, PRL.CHANGED_AFTER_RESEARCH_FLAG
, PRL.VENDOR_ID
, PRL.VENDOR_SITE_ID
, PRL.VENDOR_CONTACT_ID
, PRL.RESEARCH_AGENT_ID
, PRL.ON_LINE_FLAG
, PRL.WIP_ENTITY_ID
, PRL.WIP_LINE_ID
, PRL.WIP_REPETITIVE_SCHEDULE_ID
, PRL.WIP_OPERATION_SEQ_NUM
, PRL.WIP_RESOURCE_SEQ_NUM
, PRL.ATTRIBUTE_CATEGORY
, PRL.DESTINATION_CONTEXT
, PRL.INVENTORY_SOURCE_CONTEXT
, PRL.VENDOR_SOURCE_CONTEXT
, PRL.ATTRIBUTE1
, PRL.ATTRIBUTE2
, PRL.ATTRIBUTE3
, PRL.ATTRIBUTE4
, PRL.ATTRIBUTE5
, PRL.ATTRIBUTE6
, PRL.ATTRIBUTE7
, PRL.ATTRIBUTE8
, PRL.ATTRIBUTE9
, PRL.ATTRIBUTE10
, PRL.ATTRIBUTE11
, PRL.ATTRIBUTE12
, PRL.ATTRIBUTE13
, PRL.ATTRIBUTE14
, PRL.ATTRIBUTE15
, PRL.BOM_RESOURCE_ID
, PRL.REQUEST_ID
, PRL.PROGRAM_APPLICATION_ID
, PRL.PROGRAM_ID
, PRL.PROGRAM_UPDATE_DATE
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.CLOSED_REASON
, PRL.CLOSED_DATE
, PRL.TRANSACTION_REASON_CODE
, PRL.QUANTITY_RECEIVED
, PRL.SOURCE_REQ_LINE_ID
, PRL.ORG_ID
, PRL.GLOBAL_ATTRIBUTE1
, PRL.GLOBAL_ATTRIBUTE2
, PRL.GLOBAL_ATTRIBUTE3
, PRL.GLOBAL_ATTRIBUTE4
, PRL.GLOBAL_ATTRIBUTE5
, PRL.GLOBAL_ATTRIBUTE6
, PRL.GLOBAL_ATTRIBUTE7
, PRL.GLOBAL_ATTRIBUTE8
, PRL.GLOBAL_ATTRIBUTE9
, PRL.GLOBAL_ATTRIBUTE10
, PRL.GLOBAL_ATTRIBUTE11
, PRL.GLOBAL_ATTRIBUTE12
, PRL.GLOBAL_ATTRIBUTE13
, PRL.GLOBAL_ATTRIBUTE14
, PRL.GLOBAL_ATTRIBUTE15
, PRL.GLOBAL_ATTRIBUTE16
, PRL.GLOBAL_ATTRIBUTE17
, PRL.GLOBAL_ATTRIBUTE18
, PRL.GLOBAL_ATTRIBUTE19
, PRL.GLOBAL_ATTRIBUTE20
, PRL.GLOBAL_ATTRIBUTE_CATEGORY
, PRL.KANBAN_CARD_ID
, PRL.CATALOG_TYPE
, PRL.CATALOG_SOURCE
, PRL.MANUFACTURER_ID
, PRL.MANUFACTURER_NAME
, PRL.MANUFACTURER_PART_NUMBER
, PRL.REQUESTER_EMAIL
, PRL.REQUESTER_FAX
, PRL.REQUESTER_PHONE
, PRL.UNSPSC_CODE
, PRL.OTHER_CATEGORY_CODE
, PRL.SUPPLIER_DUNS
, PRL.TAX_STATUS_INDICATOR
, PRL.PCARD_FLAG
, PRL.NEW_SUPPLIER_FLAG
, PRL.AUTO_RECEIVE_FLAG
, PRL.TAX_USER_OVERRIDE_FLAG
, PRL.TAX_CODE_ID
, PRL.NOTE_TO_VENDOR
, PRL.OKE_CONTRACT_VERSION_ID
, PRL.OKE_CONTRACT_HEADER_ID
, PRL.ITEM_SOURCE_ID
, PRL.SUPPLIER_REF_NUMBER
, PRL.SECONDARY_UNIT_OF_MEASURE
, PRL.SECONDARY_QUANTITY
, PRL.PREFERRED_GRADE
, PRL.SECONDARY_QUANTITY_RECEIVED
, PRL.SECONDARY_QUANTITY_CANCELLED
, PRL.VMI_FLAG
, PRL.AUCTION_HEADER_ID
, PRL.AUCTION_DISPLAY_NUMBER
, PRL.AUCTION_LINE_NUMBER
, PRL.REQS_IN_POOL_FLAG
, PRL.BID_NUMBER
, PRL.BID_LINE_NUMBER
, PRL.NONCAT_TEMPLATE_ID
, PRL.SUGGESTED_VENDOR_CONTACT_FAX
, PRL.SUGGESTED_VENDOR_CONTACT_EMAIL
, PRL.AMOUNT
, PRL.CURRENCY_AMOUNT
, PRL.LABOR_REQ_LINE_ID
, PRL.JOB_ID
, PRL.JOB_LONG_DESCRIPTION
, PRL.CONTRACTOR_STATUS
, PRL.CONTACT_INFORMATION
, PRL.SUGGESTED_SUPPLIER_FLAG
, PRL.CANDIDATE_SCREENING_REQD_FLAG
, PRL.ASSIGNMENT_END_DATE
, PRL.OVERTIME_ALLOWED_FLAG
, PRL.CONTRACTOR_REQUISITION_FLAG
, PRL.DROP_SHIP_FLAG
, PRL.CANDIDATE_FIRST_NAME
, PRL.CANDIDATE_LAST_NAME
, PRL.ASSIGNMENT_START_DATE
, PRL.ORDER_TYPE_LOOKUP_CODE
, PRL.PURCHASE_BASIS
, PRL.MATCHING_BASIS
, PRL.NEGOTIATED_BY_PREPARER_FLAG
, PRL.SHIP_METHOD
, PRL.ESTIMATED_PICKUP_DATE
, PRL.SUPPLIER_NOTIFIED_FOR_CANCEL
, PRL.BASE_UNIT_PRICE
, PRL.AT_SOURCING_FLAG
, PRL.TAX_ATTRIBUTE_UPDATE_CODE
, PRL.TAX_NAME
, PRL.TRANSFERRED_TO_OE_FLAG
, PRL.CONFORMED_LINE_ID
, PRL.AMENDMENT_TYPE
, PRL.AMENDMENT_STATUS
, PRL.LINE_NUM_DISPLAY
, PRL.GROUP_LINE_ID
, PRL.CLM_INFO_FLAG
, PRL.CLM_OPTION_INDICATOR
, PRL.CLM_BASE_LINE_NUM
, PRL.CLM_OPTION_NUM
, PRL.CLM_OPTION_FROM_DATE
, PRL.CLM_OPTION_TO_DATE
, PRL.CLM_FUNDED_FLAG
, PRL.UDA_TEMPLATE_ID
, PRL.CONTRACT_TYPE
, PRL.COST_CONSTRAINT
, PRL.AMENDMENT_RESPONSE_REASON
, PRL.CLM_PERIOD_PERF_START_DATE
, PRL.CLM_PERIOD_PERF_END_DATE
, PRL.CLM_EXTENDED_ITEM_DESCRIPTION
, PRL.CLM_OPTION_EXERCISED
FROM PO_REQUISITION_LINES PRL
WHERE NVL(PRL.CLM_INFO_FLAG
, 'N') = 'N'
AND NVL(PRL.CLM_OPTION_INDICATOR
, 'B') <> 'O'
AND PO_CLM_INTG_GRP.HIDE_NONFUNDED ( 'REQUISITION'
, PRL.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, NULL
, NULL) <> 'Y'