View: PO_LINES_INQ_V

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

View Text

SELECT POL.ROWID
, POL.MARKET_PRICE
, DECODE(POL.CANCEL_FLAG
, 'I'
, NULL
, POL.CANCEL_FLAG)
, POL.CANCEL_DATE
, NVL(POL.FIRM_STATUS_LOOKUP_CODE
, 'N')
, POL.CONTRACT_NUM
, ATC.NAME
, POL.PO_HEADER_ID
, POL.LINE_NUM
, POL.CREATION_DATE
, POL.ITEM_REVISION
, POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, POL.COMMITTED_AMOUNT
, POL.NOT_TO_EXCEED_PRICE
, POL.QUANTITY
, POL.HAZARD_CLASS_ID
, POL.FROM_HEADER_ID
, POL.PROGRAM_ID
, POL.PROGRAM_UPDATE_DATE
, POL.REQUEST_ID
, POL.USSGL_TRANSACTION_CODE
, POL.CLOSED_DATE
, POL.CLOSED_REASON
, POL.TRANSACTION_REASON_CODE
, POL.CATEGORY_ID
, POL.PRICE_TYPE_LOOKUP_CODE
, POL.PRICE_BREAK_LOOKUP_CODE
, POL.QTY_RCV_TOLERANCE
, POL.TYPE_1099
, POL.CAPITAL_EXPENSE_FLAG
, POL.NEGOTIATED_BY_PREPARER_FLAG
, POL.MIN_RELEASE_AMOUNT
, NVL(POL.CLOSED_CODE
, 'OPEN')
, POL.GOVERNMENT_CONTEXT
, POL.PROGRAM_APPLICATION_ID
, POL.MIN_ORDER_QUANTITY
, POL.MAX_ORDER_QUANTITY
, POL.OVER_TOLERANCE_ERROR_FLAG
, POL.UNORDERED_FLAG
, POL.CLOSED_FLAG
, NVL(POL.USER_HOLD_FLAG
, 'N')
, POL.CANCEL_REASON
, POL.FIRM_DATE
, POL.VENDOR_PRODUCT_NUM
, POL.TAXABLE_FLAG
, POL.PO_LINE_ID
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.LINE_TYPE_ID
, POL.LAST_UPDATE_LOGIN
, POL.CREATED_BY
, POL.ITEM_ID
, POL.ITEM_DESCRIPTION
, POL.QUANTITY_COMMITTED
, POL.ALLOW_PRICE_OVERRIDE_FLAG
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_PRICE
, POL.UN_NUMBER_ID
, POL.NOTE_TO_VENDOR
, POL.FROM_LINE_ID
, POL.REFERENCE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, PLT.LINE_TYPE
, PLT.ORDER_TYPE_LOOKUP_CODE
, NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N')
, MUOM.UOM_CLASS
, POUNT.UN_NUMBER
, PHCT.HAZARD_CLASS
, NULL
, NULL
, NULL
, NULL
, POH2.QUOTE_VENDOR_QUOTE_NUMBER
, POH.SEGMENT1
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, POVS.VENDOR_SITE_CODE
, DECODE (POVC.LAST_NAME
, NULL
, NULL
, POVC.LAST_NAME||'
, '|| POVC.FIRST_NAME)
, POH.AGENT_ID
, POH.BILL_TO_LOCATION_ID
, HRL.LOCATION_CODE
, POH.SHIP_TO_LOCATION_ID
, HRL2.LOCATION_CODE
, POH.CURRENCY_CODE
, POH.TYPE_LOOKUP_CODE
, POH.REVISION_NUM
, PDTL.TYPE_NAME
, NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, NULL
, POH.CREATION_DATE
, POH.APPROVED_DATE
, POH.REVISED_DATE
, APT.NAME
, POH.SHIP_VIA_LOOKUP_CODE
, NULL
, NULL
, GLDC.USER_CONVERSION_TYPE
, POH.RATE_DATE
, POH.RATE
, POH.START_DATE
, POH.END_DATE
, POH.BLANKET_TOTAL_AMOUNT
, POH.NOTE_TO_RECEIVER
, POH.CONFIRMING_ORDER_FLAG
, POH.ACCEPTANCE_DUE_DATE
, POL.CLOSED_BY
, POL.CANCELLED_BY
, DECODE ( POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, NULL
, POL.EXPIRATION_DATE )
, POL.TAX_CODE_ID
, POL.QC_GRADE
, POL.BASE_UOM
, POL.BASE_QTY
, POL.SECONDARY_UOM
, POL.SECONDARY_QTY
, POL.OKE_CONTRACT_HEADER_ID
, POL.OKE_CONTRACT_VERSION_ID
, POL.SECONDARY_UNIT_OF_MEASURE
, POL.SECONDARY_QUANTITY
, POL.PREFERRED_GRADE
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POL.AUCTION_HEADER_ID
, POL.AUCTION_DISPLAY_NUMBER
, POL.AUCTION_LINE_NUMBER
, POL.BID_NUMBER
, POL.BID_LINE_NUMBER
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ORG_ID
, POH.ORG_ID
, POH.CONSIGNED_CONSUMPTION_FLAG
, POL.SUPPLIER_REF_NUMBER
, POL.CONTRACT_ID
, POL.JOB_ID
, POL.AMOUNT
, POL.START_DATE
, DECODE ( POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.EXPIRATION_DATE
, NULL )
, POL.CONTRACTOR_FIRST_NAME
, POL.CONTRACTOR_LAST_NAME
, PLT.PURCHASE_BASIS
, HOUTL.NAME
, POL.FROM_LINE_LOCATION_ID
, POL.BASE_UNIT_PRICE
, DECODE (POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, (DECODE ( DECODE (POL.FROM_LINE_ID
, NULL
, DECODE (POL.CONTRACT_ID
, NULL
, 'NO REFERENCE'
, 'CONTRACT')
, 'GA OR QUOTATION')
, 'NO REFERENCE'
, NULL
, DECODE (MANUAL_PRICE_CHANGE_FLAG
, 'Y'
, 'N'
, 'Y') )))
, POH.CONTERMS_EXIST_FLAG
, PDT.SECURITY_LEVEL_CODE
FROM PO_LINES_ALL POL
, PO_HEADERS_ALL POH
, PO_HEADERS_ALL POH2
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, PO_VENDOR_CONTACTS POVC
, GL_DAILY_CONVERSION_TYPES GLDC
, HR_LOCATIONS_ALL_TL HRL
, HR_LOCATIONS_ALL_TL HRL2
, AP_TERMS APT
, AP_TAX_CODES_ALL ATC
, PO_UN_NUMBERS_TL POUNT
, PO_HAZARD_CLASSES_TL PHCT
, PO_LINE_TYPES PLT
, MTL_UNITS_OF_MEASURE MUOM
, PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'Y'
AND ( (POH.ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR ( EXISTS ( SELECT 'ENABLED IN CURRENT OU'
FROM PO_GA_ORG_ASSIGNMENTS POGA
WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID
AND POGA.ENABLED_FLAG ='Y'
AND ( (POGA.ORGANIZATION_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR (POGA.PURCHASING_ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) ) )
AND POH.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL(POH.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.FROZEN_FLAG
, 'N') = 'N'
AND ( TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.START_DATE)
, TRUNC(SYSDATE) -1)
AND NVL(TRUNC(POH.END_DATE)
, TRUNC(SYSDATE)+1) OR ( TRUNC(POH.START_DATE) IS NOT NULL
AND SYSDATE <= POH.START_DATE ) )
AND TRUNC(SYSDATE) <= NVL(TRUNC(POL.EXPIRATION_DATE)
, TRUNC(SYSDATE))
AND NVL(POL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL(POL.CANCEL_FLAG
, 'N') = 'N' ) ) ) OR ( NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'N'
AND ( ( POL.ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR EXISTS ( SELECT PRL.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_REQUISITION_LINES_ALL PRL
, PO_SYSTEM_PARAMETERS PSP
WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PSP.ORG_ID = PRL.ORG_ID ) ) ) )
AND PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
AND MUOM.UNIT_OF_MEASURE (+) = POL.UNIT_MEAS_LOOKUP_CODE
AND POUNT.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID
AND POUNT.LANGUAGE (+) = USERENV('LANG')
AND PHCT.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID
AND PHCT.LANGUAGE (+) = USERENV('LANG')
AND POH2.PO_HEADER_ID (+) = POL.FROM_HEADER_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID
AND POVC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID
AND HRL.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID
AND HRL.LANGUAGE (+) = USERENV('LANG')
AND HRL2.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID
AND HRL2.LANGUAGE (+) = USERENV('LANG')
AND PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDTL.DOCUMENT_TYPE_CODE = PDT.DOCUMENT_TYPE_CODE
AND PDTL.DOCUMENT_SUBTYPE = PDT.DOCUMENT_SUBTYPE
AND PDTL.LANGUAGE = USERENV('LANG')
AND PDT.ORG_ID = POH.ORG_ID
AND PDTL.ORG_ID = PDT.ORG_ID
AND APT.TERM_ID (+) = POH.TERMS_ID
AND GLDC.CONVERSION_TYPE (+) = POH.RATE_TYPE
AND POL.TAX_CODE_ID = ATC.TAX_ID(+)
AND ATC.ORG_ID(+) = POL.ORG_ID
AND HOUTL.ORGANIZATION_ID(+) = POH.ORG_ID
AND HOUTL.LANGUAGE(+) = USERENV('LANG')

Columns