VIEW: APPS.PO_POS_ALL_V

Source

View Text - Preformatted

SELECT POH.SEGMENT1 , PDT.TYPE_NAME , POH.CREATION_DATE , POH.PO_HEADER_ID , HP.PARTY_NAME 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 , POH.STYLE_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, AP_SUPPLIERS PAV , HZ_PARTIES HP, HR_ALL_ORGANIZATION_UNITS_TL HROU WHERE PAV.VENDOR_ID (+) = POH.VENDOR_ID AND PAV.PARTY_ID = HP.PARTY_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

View Text - HTML Formatted

SELECT POH.SEGMENT1
, PDT.TYPE_NAME
, POH.CREATION_DATE
, POH.PO_HEADER_ID
, HP.PARTY_NAME 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
, POH.STYLE_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
, AP_SUPPLIERS PAV
, HZ_PARTIES HP
, HR_ALL_ORGANIZATION_UNITS_TL HROU
WHERE PAV.VENDOR_ID (+) = POH.VENDOR_ID
AND PAV.PARTY_ID = HP.PARTY_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