View: PO_POS_ALL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_POS_ALL_V

View Text

SELECT POH.SEGMENT1
, PDT.TYPE_NAME
, POH.CREATION_DATE
, POH.PO_HEADER_ID
, POV.VENDOR_NAME
, POH.AGENT_ID
, FLV.MEANING DISPLAYED_FIELD
, POH.COMMENTS
, PDTB.SECURITY_LEVEL_CODE
, PO_EMPLOYEES_SV.GET_EMP_NAME(POH.AGENT_ID)
, POH.TYPE_LOOKUP_CODE
, POH.VENDOR_ID
, POH.AUTHORIZATION_STATUS
, FLV2.MEANING AUTHORIZATION_STATUS_DSP
, POH.GLOBAL_AGREEMENT_FLAG
, HROU.NAME
, POH.ORG_ID
FROM FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV2
, PO_DOCUMENT_TYPES_ALL_TL PDT
, PO_DOCUMENT_TYPES_ALL_B PDTB
, PO_HEADERS_ALL POH
, PO_VENDORS POV
, HR_ALL_ORGANIZATION_UNITS_TL HROU
WHERE POV.VENDOR_ID (+) = POH.VENDOR_ID
AND PDT.DOCUMENT_TYPE_CODE = PDTB.DOCUMENT_TYPE_CODE
AND PDT.DOCUMENT_SUBTYPE = PDTB.DOCUMENT_SUBTYPE
AND PDT.LANGUAGE = USERENV('LANG')
AND POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'PLANNED'
, 'BLANKET'
, 'CONTRACT')
AND PDTB.DOCUMENT_TYPE_CODE = DECODE(POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PO'
, 'PLANNED'
, 'PO'
, 'BLANKET'
, 'PA'
, 'CONTRACT'
, 'PA'
, NULL)
AND PDTB.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PO TYPE'
AND FLV.VIEW_APPLICATION_ID = 201
AND FLV.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV2.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND FLV2.VIEW_APPLICATION_ID = 201
AND FLV2.LOOKUP_CODE = NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND FLV2.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV2.LOOKUP_TYPE
, FLV2.VIEW_APPLICATION_ID)
AND FLV2.LANGUAGE = USERENV('LANG')
AND ( ( POH.ORG_ID IN( SELECT FSP.ORG_ID
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)
AND NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'N' ) OR ( NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'Y') = 'Y'
AND EXISTS ( SELECT 'ORG IS ENABLED'
FROM PO_GA_ORG_ASSIGNMENTS PGOA
WHERE PGOA.PO_HEADER_ID = POH.PO_HEADER_ID
AND ( (PGOA.ORGANIZATION_ID IN( SELECT FSP.ORG_ID
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)) OR (PGOA.PURCHASING_ORG_ID IN( SELECT FSP.ORG_ID
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)) )
AND PGOA.ENABLED_FLAG = 'Y' ) ) )
AND HROU.ORGANIZATION_ID(+) = POH.ORG_ID
AND HROU.LANGUAGE (+) = USERENV('LANG')
AND PDT.ORG_ID = POH.ORG_ID
AND PDT.ORG_ID = PDTB.ORG_ID

Columns