View: POR_VIEW_LINE_DETAILS_V

Product:	ICX - Oracle iProcurement
Description:	This view is obsolete
Implementation/DBA Data:	APPS.POR_VIEW_LINE_DETAILS_V

View Text

SELECT PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_HEADER_ID
, NVL(PRL.ITEM_ID
, -9999)
, MSI.SEGMENT1
, PRL.ITEM_REVISION
, PRL.ITEM_DESCRIPTION
, PRL.CATEGORY_ID
, MTLC.CONCATENATED_SEGMENTS
, MTLC.DESCRIPTION
, TO_CHAR(PRL.NEED_BY_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.UNIT_PRICE
, PRL.UNIT_PRICE
, PRL.QUANTITY
, PRL.TAX_STATUS_INDICATOR
, PLC_SUPP.DISPLAYED_FIELD
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_PRODUCT_CODE
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.SUGGESTED_VENDOR_CONTACT
, PRL.SUGGESTED_VENDOR_PHONE
, PV.SEGMENT1
, PRL.SUPPLIER_DUNS
, PRL.MANUFACTURER_NAME
, PRL.MANUFACTURER_PART_NUMBER
, PRL.TO_PERSON_ID
, HRE.FULL_NAME
, PRL.REQUESTER_EMAIL
, PRL.REQUESTER_PHONE
, PRL.REQUESTER_FAX
, PRL.DELIVER_TO_LOCATION_ID
, HRL.LOCATION_CODE
, PRL.DESTINATION_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, PLC_INV_REPL.DISPLAYED_FIELD
, PRL.DESTINATION_SUBINVENTORY
, DIST.PROJECT_ID
, DIST.PROJECT
, DIST.TASK_ID
, DIST.TASK_NAME
, DIST.EXPENDITURE_TYPE
, DIST.EXPENDITURE_ORG_ID
, DIST.EXPENDITURE_ORG
, TO_CHAR(DIST.EXPENDITURE_ITEM_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, PRH.NOTE_TO_AUTHORIZER
, PRL.NOTE_TO_AGENT
, PRL.NOTE_TO_RECEIVER
, PRL.NOTE_TO_VENDOR
, TO_CHAR(PRL.UNIT_PRICE * (PRL.QUANTITY - NVL(PRL.QUANTITY_CANCELLED
, 0))
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
, PRL.CURRENCY_CODE
, PRL.HAZARD_CLASS_ID
, PHC.HAZARD_CLASS
, PRL.LINE_NUM
, PRL.LINE_TYPE_ID
, PLT.LINE_TYPE
, PH_SOURCE_DOC.SEGMENT1
, PRL.BLANKET_PO_LINE_NUM
, PRL.DOCUMENT_TYPE_CODE
, PRL.UNSPSC_CODE
, 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.PCARD_FLAG
, DIST.CONCATENATED_SEGMENTS
, PRL.CATALOG_TYPE
, PH.SEGMENT1
, PLC.DISPLAYED_FIELD
, AGENT.FULL_NAME
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS MSI
, MTL_CATEGORIES_KFV MTLC
, PO_VENDORS PV
, PO_HEADERS PH_SOURCE_DOC
, PO_LINE_LOCATIONS PLL
, PO_HEADERS PH
, PO_LOOKUP_CODES PLC
, HR_EMPLOYEES_CURRENT_V AGENT
, PO_HAZARD_CLASSES PHC
, PO_LINE_TYPES PLT
, HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS HRL
, GL_SETS_OF_BOOKS SOB
, PO_LOOKUP_CODES PLC_SUPP
, PO_LOOKUP_CODES PLC_INV_REPL
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
, (SELECT /*+ INDEX(PRD2$PO_REQ_DISTRIBUTIONS_N1) */ PRD2.REQUISITION_LINE_ID
, DECODE (COUNT(DISTINCT NVL(PRD2.CODE_COMBINATION_ID
, 0))
, 1
, MIN(CC.CONCATENATED_SEGMENTS)
, MIN('MULTIPLE_VALUE')) AS CONCATENATED_SEGMENTS
, MIN(PRD2.PROJECT_ID) AS PROJECT_ID
, MIN(PROJECTS.SEGMENT1) AS PROJECT
, MIN(PRD2.TASK_ID) AS TASK_ID
, MIN(TASKS.TASK_NUMBER) AS TASK_NAME
, MIN(PRD2.EXPENDITURE_TYPE) AS EXPENDITURE_TYPE
, MIN(PRD2.EXPENDITURE_ORGANIZATION_ID) AS EXPENDITURE_ORG_ID
, MIN(ORGS.NAME) AS EXPENDITURE_ORG
, MIN(PRD2.EXPENDITURE_ITEM_DATE) AS EXPENDITURE_ITEM_DATE
FROM PO_REQ_DISTRIBUTIONS PRD2
, GL_CODE_COMBINATIONS_KFV CC
, PA_PROJECTS PROJECTS
, PA_TASKS TASKS
, PA_ORGANIZATIONS_EXPEND_V ORGS
, GL_SETS_OF_BOOKS SOB2
, FINANCIALS_SYSTEM_PARAMETERS FSP2
WHERE PRD2.EXPENDITURE_ORGANIZATION_ID = ORGS.ORGANIZATION_ID(+)
AND PRD2.PROJECT_ID = PROJECTS.PROJECT_ID(+)
AND PRD2.TASK_ID = TASKS.TASK_ID(+)
AND CC.CODE_COMBINATION_ID = PRD2.CODE_COMBINATION_ID
AND CC.CHART_OF_ACCOUNTS_ID = SOB2.CHART_OF_ACCOUNTS_ID
AND SOB2.SET_OF_BOOKS_ID = FSP2.SET_OF_BOOKS_ID GROUP BY PRD2.REQUISITION_LINE_ID) DIST
WHERE PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND PRL.DESTINATION_ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND PRL.CATEGORY_ID = MTLC.CATEGORY_ID
AND PRL.VENDOR_ID = PV.VENDOR_ID (+)
AND PRL.TO_PERSON_ID = HRE.EMPLOYEE_ID
AND PRL.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID
AND PRL.DESTINATION_ORGANIZATION_ID = OOD.ORGANIZATION_ID (+)
AND PRL.REQUISITION_LINE_ID = DIST.REQUISITION_LINE_ID
AND PRL.BLANKET_PO_HEADER_ID = PH_SOURCE_DOC.PO_HEADER_ID(+)
AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)
AND PLL.PO_HEADER_ID = PH.PO_HEADER_ID(+)
AND NVL(PH.AUTHORIZATION_STATUS
, 'INCOMPLETE') = PLC.LOOKUP_CODE(+)
AND PLC.LOOKUP_TYPE(+) = 'AUTHORIZATION STATUS'
AND PH.AGENT_ID = AGENT.EMPLOYEE_ID(+)
AND PRL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID(+)
AND PLC_SUPP.LOOKUP_CODE = NVL(PRL.NEW_SUPPLIER_FLAG
, 'N')
AND PLC_SUPP.LOOKUP_TYPE = 'YES/NO'
AND PLC_INV_REPL.LOOKUP_CODE = DECODE(PRL.DESTINATION_TYPE_CODE
, 'INVENTORY'
, 'Y'
, 'N')
AND PLC_INV_REPL.LOOKUP_TYPE = 'YES/NO'
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID

Columns