View: PO_REQUISITION_LINES_INQ_V

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

View Text

SELECT PRL.ROWID
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, PLTT.LINE_TYPE
, PLTT.LINE_TYPE_ID
, PRL.ITEM_ID
, PRL.ITEM_REVISION
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.QUANTITY
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_RECEIVED
, 0))
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_DELIVERED
, 0))
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_CANCELLED
, 0))
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.NEED_BY_DATE
, PRL.NOTE_TO_AGENT
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.SUGGESTED_VENDOR_CONTACT
, PRL.SUGGESTED_VENDOR_PHONE
, PRL.RFQ_REQUIRED_FLAG
, PRL.ON_RFQ_FLAG
, PRL.CANCEL_FLAG
, PRL.MODIFIED_BY_AGENT_FLAG
, POUN.UN_NUMBER
, PHC.HAZARD_CLASS
, NULL
, PRL.REFERENCE_NUM
, PRL.URGENT_FLAG
, PRL.JUSTIFICATION
, PRL.NOTE_TO_RECEIVER
, PRL.ENCUMBERED_FLAG
, PRL.DESTINATION_TYPE_CODE
, PRL.SOURCE_TYPE_CODE
, HOUT2.NAME
, HRL1.LOCATION_CODE
, PRL.DESTINATION_SUBINVENTORY
, HOUT.NAME
, PRL.SOURCE_SUBINVENTORY
, 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.ATTRIBUTE_CATEGORY
, NVL(PLTB.OUTSIDE_OPERATION_FLAG
, 'N')
, PRL.DELIVER_TO_LOCATION_ID
, PRL.TO_PERSON_ID
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATED_BY
, PRL.LAST_UPDATE_LOGIN
, PRL.CREATION_DATE
, PRL.CREATED_BY
, PRL.SUGGESTED_VENDOR_PRODUCT_CODE
, PRL.UN_NUMBER_ID
, PRL.HAZARD_CLASS_ID
, NVL(PRL.CURRENCY_CODE
, GSB.CURRENCY_CODE)
, PRL.RATE
, PRL.RATE_TYPE
, PRL.RATE_DATE
, PRL.CURRENCY_UNIT_PRICE
, PRL.SUGGESTED_BUYER_ID
, PRL.CLOSED_CODE
, PRL.LINE_LOCATION_ID
, PRL.PARENT_REQ_LINE_ID
, PRL.PURCHASING_AGENT_ID
, PRL.DOCUMENT_TYPE_CODE
, PRL.BLANKET_PO_HEADER_ID
, PRL.BLANKET_PO_LINE_NUM
, PRL.CANCEL_REASON
, PRL.CANCEL_DATE
, 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
, WPE.WIP_ENTITY_NAME
, WPL.LINE_CODE
, BMR.RESOURCE_CODE
, BMR.UNIT_OF_MEASURE
, PRL.DESTINATION_CONTEXT
, PRL.INVENTORY_SOURCE_CONTEXT
, PRL.VENDOR_SOURCE_CONTEXT
, PRL.BOM_RESOURCE_ID
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.CLOSED_REASON
, PRL.CLOSED_DATE
, PRL.TRANSACTION_REASON_CODE
, PRL.SOURCE_REQ_LINE_ID
, PRL.DESTINATION_ORGANIZATION_ID
, PRL.SOURCE_ORGANIZATION_ID
, PLTB.ORDER_TYPE_LOOKUP_CODE
, GDT.USER_CONVERSION_TYPE
, MSI.STOCK_ENABLED_FLAG
, NVL(MSI.INTERNAL_ORDER_ENABLED_FLAG
, 'N')
, NVL(MSI.PURCHASING_ENABLED_FLAG
, 'N')
, NVL(MSI.OUTSIDE_OPERATION_FLAG
, 'N')
, MSI.INVENTORY_ASSET_FLAG
, MUOM.UOM_CLASS
, NULL
, NULL
, NULL
, MSI.FULL_LEAD_TIME
, POLA.CUSTOMER_ID
, POLA.ADDRESS_ID
, POLA.SITE_USE_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, PRH.AUTHORIZATION_STATUS
, NULL
, PRH.TYPE_LOOKUP_CODE
, PDTL.TYPE_NAME
, PRH.INTERFACE_SOURCE_CODE
, PRH.DESCRIPTION
, PRH.EMERGENCY_PO_NUM
, 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.NEW_SUPPLIER_FLAG
, PRL.AUTO_RECEIVE_FLAG
, DECODE(NVL(PRL.PCARD_FLAG
, 'N')
, 'N'
, NULL
, 'S'
, -99999
, PRH.PCARD_ID) PCARD_ID
, ATC.NAME
, PRL.TAX_CODE_ID
, PRL.OKE_CONTRACT_HEADER_ID
, PRL.OKE_CONTRACT_VERSION_ID
, PRL.SECONDARY_UNIT_OF_MEASURE
, PRL.SECONDARY_QUANTITY
, PRL.PREFERRED_GRADE
, PRL.SECONDARY_QUANTITY_RECEIVED
, PRL.SECONDARY_QUANTITY_CANCELLED
, PRL.AUCTION_HEADER_ID
, PRL.AUCTION_DISPLAY_NUMBER
, PRL.AUCTION_LINE_NUMBER
, PRL.REQS_IN_POOL_FLAG
, PRL.VMI_FLAG
, PRL.BID_NUMBER
, PRL.BID_LINE_NUMBER
, PRL.SUPPLIER_REF_NUMBER
, PRL.AMOUNT
, PRL.CURRENCY_AMOUNT
, PRL.JOB_ID
, PRL.CANDIDATE_FIRST_NAME
, PRL.CANDIDATE_LAST_NAME
, PRL.ASSIGNMENT_END_DATE
, PRL.LABOR_REQ_LINE_ID
, PRL.CONTRACTOR_REQUISITION_FLAG
, PLTB.PURCHASE_BASIS
, PRL.DROP_SHIP_FLAG
, PRL.ASSIGNMENT_START_DATE
, PRL.ORG_ID
, HOUTL3.NAME
, HOUTL4.NAME
, PRL.SUGGESTED_VENDOR_CONTACT_FAX
, PRL.SUGGESTED_VENDOR_CONTACT_EMAIL
, PRL.BASE_UNIT_PRICE
, PRL.AT_SOURCING_FLAG
, PRH.CONTRACTOR_STATUS
, PODB.SECURITY_LEVEL_CODE
FROM GL_SETS_OF_BOOKS GSB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_LINE_TYPES_TL PLTT
, PO_LINE_TYPES_B PLTB
, GL_DAILY_CONVERSION_TYPES GDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, MTL_UNITS_OF_MEASURE MUOM
, PO_LOCATION_ASSOCIATIONS_ALL POLA
, PO_UN_NUMBERS_TL POUN
, PO_HAZARD_CLASSES_TL PHC
, HR_LOCATIONS_ALL_TL HRL1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ALL_ORGANIZATION_UNITS_TL HOUT2
, MTL_SYSTEM_ITEMS MSI
, WIP_ENTITIES WPE
, WIP_LINES WPL
, BOM_RESOURCES BMR
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, AP_TAX_CODES_ALL ATC
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL3
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL4
, PO_LINE_LOCATIONS_ALL POLL1
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND ( (FSP.ORG_ID = PRH.ORG_ID
AND FSP.ORG_ID = PRL.ORG_ID) OR (FSP.ORG_ID = POLL1.ORG_ID
AND FSP.ORG_ID = PRL.ORG_ID) )
AND FSP.ORG_ID = PRL.ORG_ID
AND POLL1.LINE_LOCATION_ID(+) = PRL.LINE_LOCATION_ID
AND NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')<>'SYSTEM_SAVED'
AND PLTB.LINE_TYPE_ID = PRL.LINE_TYPE_ID
AND PLTB.LINE_TYPE_ID = PLTT.LINE_TYPE_ID
AND PLTT.LANGUAGE = USERENV('LANG')
AND POUN.UN_NUMBER_ID (+) = PRL.UN_NUMBER_ID
AND POUN.LANGUAGE(+) = USERENV('LANG')
AND PHC.HAZARD_CLASS_ID (+) = PRL.HAZARD_CLASS_ID
AND PHC.LANGUAGE(+) = USERENV('LANG')
AND HRL1.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID
AND HRL1.LANGUAGE(+) = USERENV('LANG')
AND MSI.INVENTORY_ITEM_ID (+) = PRL.ITEM_ID
AND MSI.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND MUOM.UNIT_OF_MEASURE (+) = PRL.UNIT_MEAS_LOOKUP_CODE
AND POLA.LOCATION_ID (+) = PRL.DELIVER_TO_LOCATION_ID
AND POLA.ORG_ID(+) = PRL.ORG_ID
AND GDT.CONVERSION_TYPE (+) = PRL.RATE_TYPE
AND WPE.WIP_ENTITY_ID (+) = PRL.WIP_ENTITY_ID
AND WPE.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND WPL.LINE_ID (+) = PRL.WIP_LINE_ID
AND WPL.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND BMR.RESOURCE_ID (+) = PRL.BOM_RESOURCE_ID
AND BMR.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND PDTL.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PDTL.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDTL.LANGUAGE = USERENV('LANG')
AND PDTL.ORG_ID = PRL.ORG_ID
AND FSP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND PRL.TAX_CODE_ID = ATC.TAX_ID(+)
AND ATC.ORG_ID(+) = PRL.ORG_ID
AND HOUT.ORGANIZATION_ID(+) = PRL.SOURCE_ORGANIZATION_ID
AND HOUT.LANGUAGE(+)= USERENV('LANG')
AND HOUT2.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID
AND HOUT2.LANGUAGE(+) = USERENV('LANG')
AND HOUTL3.ORGANIZATION_ID(+) = PRL.ORG_ID
AND HOUTL3.LANGUAGE(+) = USERENV('LANG')
AND HOUTL4.ORGANIZATION_ID(+) = POLL1.ORG_ID
AND HOUTL4.LANGUAGE(+)= USERENV('LANG')
AND PODB.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE
AND PDTL.ORG_ID = PODB.ORG_ID

Columns