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.

[Home] [Help]

VIEW: CZ.CZ_EXP_TMP_LINES#

Source

View Text - Preformatted


select CONFIG_ID CONFIG_ID, SELF_LINE SELF_LINE, CHILD_ID CHILD_ID, PARENT_ID PARENT_ID, PARENT_LINE PARENT_LINE, ROOT_LINE ROOT_LINE, ROOT_ID ROOT_ID, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE, PS_NODE_TYPE PS_NODE_TYPE, QUOTE_HDR_ID QUOTE_HDR_ID, QUOTE_REV_NBR QUOTE_REV_NBR, BOM_REQUIRED_FLAG BOM_REQUIRED_FLAG, QUANTITY QUANTITY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY from "CZ"."CZ_EXP_TMP_LINES"

View Text - HTML Formatted

SELECT CONFIG_ID CONFIG_ID
, SELF_LINE SELF_LINE
, CHILD_ID CHILD_ID
, PARENT_ID PARENT_ID
, PARENT_LINE PARENT_LINE
, ROOT_LINE ROOT_LINE
, ROOT_ID ROOT_ID
, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE
, PS_NODE_TYPE PS_NODE_TYPE
, QUOTE_HDR_ID QUOTE_HDR_ID
, QUOTE_REV_NBR QUOTE_REV_NBR
, BOM_REQUIRED_FLAG BOM_REQUIRED_FLAG
, QUANTITY QUANTITY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "CZ"."CZ_EXP_TMP_LINES"