View: PO_REQUISITION_LINES_MRC_V

View Text

SELECT PO.REQUISITION_LINE_ID
, PO.REQUISITION_HEADER_ID
, PO.LINE_NUM
, PO.LINE_TYPE_ID
, PO.CATEGORY_ID
, PO.ITEM_DESCRIPTION
, PO.UNIT_MEAS_LOOKUP_CODE
, PO.UNIT_PRICE * PO_MC_CURRENCY_PKG.FUNC_TO_REP_RATE(NVL(PO.RATE_DATE
, SYSDATE)
, PO.ORG_ID)
, PO.QUANTITY
, PO.DELIVER_TO_LOCATION_ID
, PO.TO_PERSON_ID
, PO.LAST_UPDATE_DATE
, PO.LAST_UPDATED_BY
, PO.SOURCE_TYPE_CODE
, PO.LAST_UPDATE_LOGIN
, PO.CREATION_DATE
, PO.CREATED_BY
, PO.ITEM_ID
, PO.ITEM_REVISION
, PO.QUANTITY_DELIVERED
, PO.SUGGESTED_BUYER_ID
, PO.ENCUMBERED_FLAG
, PO.RFQ_REQUIRED_FLAG
, PO.NEED_BY_DATE
, PO.LINE_LOCATION_ID
, PO.MODIFIED_BY_AGENT_FLAG
, PO.PARENT_REQ_LINE_ID
, PO.JUSTIFICATION
, PO.NOTE_TO_AGENT
, PO.NOTE_TO_RECEIVER
, PO.PURCHASING_AGENT_ID
, PO.DOCUMENT_TYPE_CODE
, PO.BLANKET_PO_HEADER_ID
, PO.BLANKET_PO_LINE_NUM
, PO.CURRENCY_CODE
, PO.RATE_TYPE
, PO.RATE_DATE
, TO_NUMBER(DECODE(PO.CURRENCY_CODE
, NULL
, NULL
, PO_MC_CURRENCY_PKG.GET_REQ_RATE(PO.CURRENCY_CODE
, NVL(PO.RATE_DATE
, SYSDATE)
, PO.ORG_ID)))
, PO.CURRENCY_UNIT_PRICE * DECODE(PO.CURRENCY_CODE
, NULL
, NULL
, PO_MC_CURRENCY_PKG.GET_REQ_RATE(PO.CURRENCY_CODE
, NVL(PO.RATE_DATE
, SYSDATE)
, PO.ORG_ID))
, PO.SUGGESTED_VENDOR_NAME
, PO.SUGGESTED_VENDOR_LOCATION
, PO.SUGGESTED_VENDOR_CONTACT
, PO.SUGGESTED_VENDOR_PHONE
, PO.SUGGESTED_VENDOR_PRODUCT_CODE
, PO.UN_NUMBER_ID
, PO.HAZARD_CLASS_ID
, PO.MUST_USE_SUGG_VENDOR_FLAG
, PO.REFERENCE_NUM
, PO.ON_RFQ_FLAG
, PO.URGENT_FLAG
, PO.CANCEL_FLAG
, PO.SOURCE_ORGANIZATION_ID
, PO.SOURCE_SUBINVENTORY
, PO.DESTINATION_TYPE_CODE
, PO.DESTINATION_ORGANIZATION_ID
, PO.DESTINATION_SUBINVENTORY
, PO.QUANTITY_CANCELLED
, PO.CANCEL_DATE
, PO.CANCEL_REASON
, PO.CLOSED_CODE
, PO.AGENT_RETURN_NOTE
, PO.CHANGED_AFTER_RESEARCH_FLAG
, PO.VENDOR_ID
, PO.VENDOR_SITE_ID
, PO.VENDOR_CONTACT_ID
, PO.RESEARCH_AGENT_ID
, PO.ON_LINE_FLAG
, PO.WIP_ENTITY_ID
, PO.WIP_LINE_ID
, PO.WIP_REPETITIVE_SCHEDULE_ID
, PO.WIP_OPERATION_SEQ_NUM
, PO.WIP_RESOURCE_SEQ_NUM
, PO.ATTRIBUTE_CATEGORY
, PO.DESTINATION_CONTEXT
, PO.INVENTORY_SOURCE_CONTEXT
, PO.VENDOR_SOURCE_CONTEXT
, PO.ATTRIBUTE1
, PO.ATTRIBUTE2
, PO.ATTRIBUTE3
, PO.ATTRIBUTE4
, PO.ATTRIBUTE5
, PO.ATTRIBUTE6
, PO.ATTRIBUTE7
, PO.ATTRIBUTE8
, PO.ATTRIBUTE9
, PO.ATTRIBUTE10
, PO.ATTRIBUTE11
, PO.ATTRIBUTE12
, PO.ATTRIBUTE13
, PO.ATTRIBUTE14
, PO.ATTRIBUTE15
, PO.BOM_RESOURCE_ID
, PO.REQUEST_ID
, PO.PROGRAM_APPLICATION_ID
, PO.PROGRAM_ID
, PO.PROGRAM_UPDATE_DATE
, PO.USSGL_TRANSACTION_CODE
, PO.GOVERNMENT_CONTEXT
, PO.CLOSED_REASON
, PO.CLOSED_DATE
, PO.TRANSACTION_REASON_CODE
, PO.QUANTITY_RECEIVED
, PO.SOURCE_REQ_LINE_ID
, PO.ORG_ID
, PO.KANBAN_CARD_ID
, CATALOG_TYPE
, CATALOG_SOURCE
, MANUFACTURER_ID
, MANUFACTURER_NAME
, MANUFACTURER_PART_NUMBER
, REQUESTER_EMAIL
, REQUESTER_FAX
, REQUESTER_PHONE
, UNSPSC_CODE
, OTHER_CATEGORY_CODE
, SUPPLIER_DUNS
, TAX_STATUS_INDICATOR
, PCARD_FLAG
, NEW_SUPPLIER_FLAG
, AUTO_RECEIVE_FLAG
, TAX_CODE_ID
, TAX_USER_OVERRIDE_FLAG
, NOTE_TO_VENDOR
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, ITEM_SOURCE_ID
, SUPPLIER_REF_NUMBER
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_CANCELLED
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, REQS_IN_POOL_FLAG
, VMI_FLAG
, BID_NUMBER
, BID_LINE_NUMBER
, AMOUNT
, CURRENCY_AMOUNT
, JOB_ID
, JOB_LONG_DESCRIPTION
, CONTACT_INFORMATION
, CANDIDATE_SCREENING_REQD_FLAG
, SUGGESTED_SUPPLIER_FLAG
, CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME
, ASSIGNMENT_END_DATE
, OVERTIME_ALLOWED_FLAG
, LABOR_REQ_LINE_ID
, CONTRACTOR_STATUS
, CONTRACTOR_REQUISITION_FLAG
, NONCAT_TEMPLATE_ID
, SUGGESTED_VENDOR_CONTACT_FAX
, SUGGESTED_VENDOR_CONTACT_EMAIL
, DROP_SHIP_FLAG
, ASSIGNMENT_START_DATE
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, SHIP_METHOD
, ESTIMATED_PICKUP_DATE
, SUPPLIER_NOTIFIED_FOR_CANCEL
, PO.BASE_UNIT_PRICE
, PO.NEGOTIATED_BY_PREPARER_FLAG
FROM PO_REQUISITION_LINES_ALL PO
WHERE NVL(PO.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns