VIEW: APPS.POS_BLANKET_AGREE_V

Source

View Text - Preformatted

SELECT poh.comments, POH.GLOBAL_AGREEMENT_FLAG, POH.ACCEPTANCE_DUE_DATE , TO_CHAR(NULL) , POH.APPROVED_DATE , POH.START_DATE, POH.END_DATE, DECODE(POH.CANCEL_FLAG, 'Y', 'CANCELLED', NVL(POH.CLOSED_CODE, 'OPEN')) , TO_CHAR(POH.BLANKET_TOTAL_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(POH.CURRENCY_CODE,30)) , TO_CHAR(NULL) , POH.REVISED_DATE , POH.REVISION_NUM , POH.AGENT_ID , POH.PO_HEADER_ID , POH.VENDOR_CONTACT_ID , POH.VENDOR_ID , POH.VENDOR_SITE_ID , NVL(POH.CLOSED_CODE, 'OPEN') , POH.CURRENCY_CODE , POH.TYPE_LOOKUP_CODE , POH.ACCEPTANCE_REQUIRED_FLAG , POH.APPROVED_FLAG , DECODE(POH.CANCEL_FLAG, 'I', NULL, POH.CANCEL_FLAG) , POH.CREATED_BY , POH.APPROVED_DATE , POH.LAST_UPDATED_BY , POH.LAST_UPDATE_DATE , POH.LAST_UPDATE_LOGIN , POH.SEGMENT1 , POH.ATTRIBUTE_CATEGORY , POH.ATTRIBUTE1 , POH.ATTRIBUTE2 , POH.ATTRIBUTE3 , POH.ATTRIBUTE4 , POH.ATTRIBUTE5 , POH.ATTRIBUTE6 , POH.ATTRIBUTE7 , POH.ATTRIBUTE8 , POH.ATTRIBUTE9 , POH.ATTRIBUTE10 , POH.ATTRIBUTE11 , POH.ATTRIBUTE12 , POH.ATTRIBUTE13 , POH.ATTRIBUTE14 , POH.ATTRIBUTE15 , POS_GET.GET_PERSON_NAME(POH.AGENT_ID) , V.VENDOR_NAME , VS.VENDOR_SITE_CODE , POLC.displayed_field, TO_CHAR(POS_TOTALS_PO_SV.GET_AMOUNT_ORDERED(POH.PO_HEADER_ID,POH.REVISION_NUM,POH.TYPE_LOOKUP_CODE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(POH.CURRENCY_CODE,30)) , POH.ORG_ID, HOU.name, decode(poh.global_agreement_flag,'Y',fnd_message.get_string('POS','POS_POTYPE_GBLA'),fnd_message.get_string('POS','POS_POTYPE_BLKT')) FROM PO_VENDORS V, PO_VENDOR_SITES_ALL VS, PO_HEADERS_ARCHIVE_ALL POH, HR_ALL_ORGANIZATION_UNITS_TL hou, PO_LOOKUP_CODES polc WHERE V.VENDOR_ID = POH.VENDOR_ID AND VS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND POH.TYPE_LOOKUP_CODE = 'BLANKET' AND POLC.LOOKUP_CODE = DECODE(POH.CANCEL_FLAG, 'Y', 'CANCELLED', NVL(POH.CLOSED_CODE, 'OPEN')) AND POLC.LOOKUP_TYPE = 'DOCUMENT STATE' AND POH.LATEST_EXTERNAL_FLAG = 'Y' AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID AND HOU.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT POH.COMMENTS
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ACCEPTANCE_DUE_DATE
, TO_CHAR(NULL)
, POH.APPROVED_DATE
, POH.START_DATE
, POH.END_DATE
, DECODE(POH.CANCEL_FLAG
, 'Y'
, 'CANCELLED'
, NVL(POH.CLOSED_CODE
, 'OPEN'))
, TO_CHAR(POH.BLANKET_TOTAL_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(POH.CURRENCY_CODE
, 30))
, TO_CHAR(NULL)
, POH.REVISED_DATE
, POH.REVISION_NUM
, POH.AGENT_ID
, POH.PO_HEADER_ID
, POH.VENDOR_CONTACT_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, NVL(POH.CLOSED_CODE
, 'OPEN')
, POH.CURRENCY_CODE
, POH.TYPE_LOOKUP_CODE
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.APPROVED_FLAG
, DECODE(POH.CANCEL_FLAG
, 'I'
, NULL
, POH.CANCEL_FLAG)
, POH.CREATED_BY
, POH.APPROVED_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
, POH.SEGMENT1
, POH.ATTRIBUTE_CATEGORY
, POH.ATTRIBUTE1
, POH.ATTRIBUTE2
, POH.ATTRIBUTE3
, POH.ATTRIBUTE4
, POH.ATTRIBUTE5
, POH.ATTRIBUTE6
, POH.ATTRIBUTE7
, POH.ATTRIBUTE8
, POH.ATTRIBUTE9
, POH.ATTRIBUTE10
, POH.ATTRIBUTE11
, POH.ATTRIBUTE12
, POH.ATTRIBUTE13
, POH.ATTRIBUTE14
, POH.ATTRIBUTE15
, POS_GET.GET_PERSON_NAME(POH.AGENT_ID)
, V.VENDOR_NAME
, VS.VENDOR_SITE_CODE
, POLC.DISPLAYED_FIELD
, TO_CHAR(POS_TOTALS_PO_SV.GET_AMOUNT_ORDERED(POH.PO_HEADER_ID
, POH.REVISION_NUM
, POH.TYPE_LOOKUP_CODE)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(POH.CURRENCY_CODE
, 30))
, POH.ORG_ID
, HOU.NAME
, DECODE(POH.GLOBAL_AGREEMENT_FLAG
, 'Y'
, FND_MESSAGE.GET_STRING('POS'
, 'POS_POTYPE_GBLA')
, FND_MESSAGE.GET_STRING('POS'
, 'POS_POTYPE_BLKT'))
FROM PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_HEADERS_ARCHIVE_ALL POH
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PO_LOOKUP_CODES POLC
WHERE V.VENDOR_ID = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POLC.LOOKUP_CODE = DECODE(POH.CANCEL_FLAG
, 'Y'
, 'CANCELLED'
, NVL(POH.CLOSED_CODE
, 'OPEN'))
AND POLC.LOOKUP_TYPE = 'DOCUMENT STATE'
AND POH.LATEST_EXTERNAL_FLAG = 'Y'
AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID
AND HOU.LANGUAGE (+) = USERENV('LANG')