View: OKC_REL_OBJ_ORDER_LINES_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_REL_OBJ_ORDER_LINES_V

View Text

SELECT OL.LINE_NUMBER||DECODE(OL.SHIPMENT_NUMBER
, NULL
, ''
, '.'||OL.SHIPMENT_NUMBER)||DECODE(OL.OPTION_NUMBER
, NULL
, ''
, '.'||OL.OPTION_NUMBER) LINE_NUMBER
, OL.HEADER_ID ORDER_HEADER_ID
, SI.DESCRIPTION DESCRIPTION
, OL.ORDERED_QUANTITY QUANTITY
, OL.TOTAL_AMOUNT AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.CHR_ID CHR_ID
, SI.NAME ITEM_NAME
FROM OKX_ORDER_LINES_V OL
, OKC_K_REL_OBJS_V REL
, OKX_SYSTEM_ITEMS_V SI
WHERE OL.ID1 = REL.OBJECT1_ID1
AND (OL.INVENTORY_ITEM_ID = SI.ID1
AND OL.ORG_ID = SI.ID2)
AND REL.JTOT_OBJECT1_CODE = 'OKX_ORDERLINE'

Columns