[Home] [Help]
View: OKC_REL_OBJ_PO_HEADERS_V
Product: | OKC - Contracts Core |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
PO_NUMBER |
PO_DESCRIPTION |
PO_STATUS |
CURRENCY |
OBJECT1_ID1 |
JTOT_OBJECT1_CODE |
CHR_ID |