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: OZF.OZF_ORDER_GROUP_PROD#

Source

View Text - Preformatted


select ORDER_GROUP_PROD_ID ORDER_GROUP_PROD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OFFER_ID OFFER_ID, QP_LIST_HEADER_ID QP_LIST_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, GROUP_NO GROUP_NO, VOLUME_TRACK_TYPE VOLUME_TRACK_TYPE, COMBINE_SCHEDULE_YN COMBINE_SCHEDULE_YN, PBH_LINE_ID PBH_LINE_ID, VOLUME_TYPE VOLUME_TYPE, PROD_ATTRIBUTE PROD_ATTRIBUTE, PROD_ATTR_VALUE PROD_ATTR_VALUE, APPLY_DISCOUNT_FLAG APPLY_DISCOUNT_FLAG, INCLUDE_VOLUME_FLAG INCLUDE_VOLUME_FLAG, INDIRECT_FLAG INDIRECT_FLAG from "OZF"."OZF_ORDER_GROUP_PROD"

View Text - HTML Formatted

SELECT ORDER_GROUP_PROD_ID ORDER_GROUP_PROD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OFFER_ID OFFER_ID
, QP_LIST_HEADER_ID QP_LIST_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, GROUP_NO GROUP_NO
, VOLUME_TRACK_TYPE VOLUME_TRACK_TYPE
, COMBINE_SCHEDULE_YN COMBINE_SCHEDULE_YN
, PBH_LINE_ID PBH_LINE_ID
, VOLUME_TYPE VOLUME_TYPE
, PROD_ATTRIBUTE PROD_ATTRIBUTE
, PROD_ATTR_VALUE PROD_ATTR_VALUE
, APPLY_DISCOUNT_FLAG APPLY_DISCOUNT_FLAG
, INCLUDE_VOLUME_FLAG INCLUDE_VOLUME_FLAG
, INDIRECT_FLAG INDIRECT_FLAG
FROM "OZF"."OZF_ORDER_GROUP_PROD"