eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKC_REL_OBJ_ORDER_LINES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'