[Home] [Help]
View: OKC_REL_OBJ_ORDER_HEADERS_V
View Text
SELECT OH.NAME ORDER_NUMBER
, OH.DESCRIPTION ORDER_DESCRIPTION
, OL.MEANING ORDER_STATUS
, OH.TOTAL_AMOUNT TOTAL_AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, REL.CHR_ID CHR_ID
, OH.TRANSACTIONAL_CURR_CODE CURRENCY
FROM OKX_ORDER_HEADERS_V OH
, FND_LOOKUP_VALUES OL
, OKC_K_REL_OBJS REL
WHERE OH.ID1 = REL.OBJECT1_ID1
AND OH.FLOW_STATUS_CODE = OL.LOOKUP_CODE
AND OL.LOOKUP_TYPE = 'FLOW_STATUS'
AND OL.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(OL.LOOKUP_TYPE
, OL.VIEW_APPLICATION_ID)
AND OL.VIEW_APPLICATION_ID=660
AND LANGUAGE=USERENV('LANG')
Columns
Name |
ORDER_NUMBER |
ORDER_DESCRIPTION |
ORDER_STATUS |
TOTAL_AMOUNT |
OBJECT1_ID1 |
JTOT_OBJECT_CODE |
CHR_ID |
CURRENCY |