View: OKC_REL_OBJ_ORDER_HEADERS_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.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