View: OKC_REL_OBJ_PO_HEADERS_V

View Text

SELECT HDR.NAME PO_NUMBER
, HDR.DESCRIPTION PO_DESCRIPTION
, OL.MEANING PO_STATUS
, HDR.CURRENCY_CODE CURRENCY
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, REL.CHR_ID CHR_ID
FROM FND_LOOKUP_VALUES OL
, OKC_K_REL_OBJS REL
, OKX_PO_HEADERS_V HDR
WHERE HDR.ID1 = REL.OBJECT1_ID1
AND JTOT_OBJECT1_CODE = 'OKX_PO_HEADERS'
AND REL.RTY_CODE = 'CONTRACTCREATESPO'
AND NVL(HDR.AUTHORIZATION_STATUS
, 'INCOMPLETE') = OL.LOOKUP_CODE
AND OL.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND OL.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(OL.LOOKUP_TYPE
, OL.VIEW_APPLICATION_ID)
AND OL.VIEW_APPLICATION_ID = 201
AND LANGUAGE=USERENV('LANG')

Columns