VIEW: APPS.PO_REQ_LINES_TRX_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'