VIEW: APPS.EGO_GTN_ATTR_CHG_VL

Source

View Text - Preformatted

SELECT B.EXTENSION_ID EXTENSION_ID, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, B.ORGANIZATION_ID ORGANIZATION_ID, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, B.REVISION_ID REVISION_ID, B.IS_TRADE_ITEM_A_CONSUMER_UNIT IS_TRADE_ITEM_A_CONSUMER_UNIT, B.IS_TRADE_ITEM_INFO_PRIVATE IS_TRADE_ITEM_INFO_PRIVATE, B.GROSS_WEIGHT GROSS_WEIGHT, B.UOM_GROSS_WEIGHT UOM_GROSS_WEIGHT, B.EFFECTIVE_DATE EFFECTIVE_DATE, B.CANCELED_DATE CANCELED_DATE, B.DISCONTINUED_DATE DISCONTINUED_DATE, B.END_AVAILABILITY_DATE_TIME END_AVAILABILITY_DATE_TIME, B.START_AVAILABILITY_DATE_TIME START_AVAILABILITY_DATE_TIME, B.BRAND_NAME BRAND_NAME, B.IS_TRADE_ITEM_A_BASE_UNIT IS_TRADE_ITEM_A_BASE_UNIT, B.IS_TRADE_ITEM_A_VARIABLE_UNIT IS_TRADE_ITEM_A_VARIABLE_UNIT, B.IS_PACK_MARKED_WITH_EXP_DATE IS_PACK_MARKED_WITH_EXP_DATE, B.IS_PACK_MARKED_WITH_GREEN_DOT IS_PACK_MARKED_WITH_GREEN_DOT, B.IS_PACK_MARKED_WITH_INGRED IS_PACK_MARKED_WITH_INGRED, B.IS_PACKAGE_MARKED_AS_REC IS_PACKAGE_MARKED_AS_REC, B.IS_PACKAGE_MARKED_RET IS_PACKAGE_MARKED_RET, B.STACKING_FACTOR STACKING_FACTOR, B.STACKING_WEIGHT_MAXIMUM STACKING_WEIGHT_MAXIMUM, B.UOM_STACKING_WEIGHT_MAXIMUM UOM_STACKING_WEIGHT_MAXIMUM, B.ORDERING_LEAD_TIME ORDERING_LEAD_TIME, B.UOM_ORDERING_LEAD_TIME UOM_ORDERING_LEAD_TIME, B.ORDER_QUANTITY_MAX ORDER_QUANTITY_MAX, B.ORDER_QUANTITY_MIN ORDER_QUANTITY_MIN, B.ORDER_QUANTITY_MULTIPLE ORDER_QUANTITY_MULTIPLE, B.ORDER_SIZING_FACTOR ORDER_SIZING_FACTOR, B.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, B.CATALOG_PRICE CATALOG_PRICE, B.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, B.SUGGESTED_RETAIL_PRICE SUGGESTED_RETAIL_PRICE, B.MATERIAL_SAFETY_DATA_SHEET_NO MATERIAL_SAFETY_DATA_SHEET_NO, B.HAS_BATCH_NUMBER HAS_BATCH_NUMBER, B.IS_NON_SOLD_TRADE_RET_FLAG IS_NON_SOLD_TRADE_RET_FLAG, B.IS_TRADE_ITEM_MAR_REC_FLAG IS_TRADE_ITEM_MAR_REC_FLAG, B.DIAMETER DIAMETER, B.UOM_DIAMETER UOM_DIAMETER, B.DRAINED_WEIGHT DRAINED_WEIGHT, B.UOM_DRAINED_WEIGHT UOM_DRAINED_WEIGHT, B.GENERIC_INGREDIENT GENERIC_INGREDIENT, B.GENERIC_INGREDIENT_STRGTH GENERIC_INGREDIENT_STRGTH, B.UOM_GENERIC_INGREDIENT_STRGTH UOM_GENERIC_INGREDIENT_STRGTH, B.INGREDIENT_STRENGTH INGREDIENT_STRENGTH, B.IS_NET_CONTENT_DEC_FLAG IS_NET_CONTENT_DEC_FLAG, B.NET_CONTENT NET_CONTENT, B.UOM_NET_CONTENT UOM_NET_CONTENT, B.PEG_HORIZONTAL PEG_HORIZONTAL, B.UOM_PEG_HORIZONTAL UOM_PEG_HORIZONTAL, B.PEG_VERTICAL PEG_VERTICAL, B.UOM_PEG_VERTICAL UOM_PEG_VERTICAL, B.CONSUMER_AVAIL_DATE_TIME CONSUMER_AVAIL_DATE_TIME, B.DEL_TO_DIST_CNTR_TEMP_MAX DEL_TO_DIST_CNTR_TEMP_MAX, B.UOM_DEL_TO_DIST_CNTR_TEMP_MAX UOM_DEL_TO_DIST_CNTR_TEMP_MAX, B.DEL_TO_DIST_CNTR_TEMP_MIN DEL_TO_DIST_CNTR_TEMP_MIN, B.UOM_DEL_TO_DIST_CNTR_TEMP_MIN UOM_DEL_TO_DIST_CNTR_TEMP_MIN, B.DELIVERY_TO_MRKT_TEMP_MAX DELIVERY_TO_MRKT_TEMP_MAX, B.UOM_DELIVERY_TO_MRKT_TEMP_MAX UOM_DELIVERY_TO_MRKT_TEMP_MAX, B.DELIVERY_TO_MRKT_TEMP_MIN DELIVERY_TO_MRKT_TEMP_MIN, B.UOM_DELIVERY_TO_MRKT_TEMP_MIN UOM_DELIVERY_TO_MRKT_TEMP_MIN, B.SUB_BRAND SUB_BRAND, B.TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR, B.EANUCC_CODE EANUCC_CODE, B.EANUCC_TYPE EANUCC_TYPE, B.RETAIL_PRICE_ON_TRADE_ITEM RETAIL_PRICE_ON_TRADE_ITEM, B.QUANTITY_OF_COMP_LAY_ITEM QUANTITY_OF_COMP_LAY_ITEM, B.QUANITY_OF_ITEM_IN_LAYER QUANITY_OF_ITEM_IN_LAYER, B.QUANTITY_OF_ITEM_INNER_PACK QUANTITY_OF_ITEM_INNER_PACK, B.TARGET_MARKET_DESC TARGET_MARKET_DESC, B.QUANTITY_OF_INNER_PACK QUANTITY_OF_INNER_PACK, B.BRAND_OWNER_GLN BRAND_OWNER_GLN, B.BRAND_OWNER_NAME BRAND_OWNER_NAME, B.STORAGE_HANDLING_TEMP_MAX STORAGE_HANDLING_TEMP_MAX, B.UOM_STORAGE_HANDLING_TEMP_MAX UOM_STORAGE_HANDLING_TEMP_MAX, B.STORAGE_HANDLING_TEMP_MIN STORAGE_HANDLING_TEMP_MIN, B.UOM_STORAGE_HANDLING_TEMP_MIN UOM_STORAGE_HANDLING_TEMP_MIN, B.TRADE_ITEM_COUPON TRADE_ITEM_COUPON, B.DEGREE_OF_ORIGINAL_WORT DEGREE_OF_ORIGINAL_WORT, B.FAT_PERCENT_IN_DRY_MATTER FAT_PERCENT_IN_DRY_MATTER, B.PERCENT_OF_ALCOHOL_BY_VOL PERCENT_OF_ALCOHOL_BY_VOL, B.ISBN_NUMBER ISBN_NUMBER, B.ISSN_NUMBER ISSN_NUMBER, B.IS_INGREDIENT_IRRADIATED IS_INGREDIENT_IRRADIATED, B.IS_RAW_MATERIAL_IRRADIATED IS_RAW_MATERIAL_IRRADIATED, B.IS_TRADE_ITEM_GENETICALLY_MOD IS_TRADE_ITEM_GENETICALLY_MOD, B.IS_TRADE_ITEM_IRRADIATED IS_TRADE_ITEM_IRRADIATED, B.PUBLICATION_STATUS PUBLICATION_STATUS, B.TOP_GTIN TOP_GTIN, B.SECURITY_TAG_LOCATION SECURITY_TAG_LOCATION, B.URL_FOR_WARRANTY URL_FOR_WARRANTY, B.NESTING_INCREMENT NESTING_INCREMENT, B.UOM_NESTING_INCREMENT UOM_NESTING_INCREMENT, B.IS_TRADE_ITEM_RECALLED IS_TRADE_ITEM_RECALLED, B.MODEL_NUMBER MODEL_NUMBER, B.PIECES_PER_TRADE_ITEM PIECES_PER_TRADE_ITEM, B.UOM_PIECES_PER_TRADE_ITEM UOM_PIECES_PER_TRADE_ITEM, B.DEPT_OF_TRNSPRT_DANG_GOODS_NUM DEPT_OF_TRNSPRT_DANG_GOODS_NUM, B.RETURN_GOODS_POLICY RETURN_GOODS_POLICY, B.IS_OUT_OF_BOX_PROVIDED IS_OUT_OF_BOX_PROVIDED, B.REGISTRATION_UPDATE_DATE REGISTRATION_UPDATE_DATE, B.TP_NEUTRAL_UPDATE_DATE TP_NEUTRAL_UPDATE_DATE, B.MASTER_ORG_EXTENSION_ID MASTER_ORG_EXTENSION_ID, B.IS_BARCODE_SYMBOLOGY_DERIVABLE IS_BARCODE_SYMBOLOGY_DERIVABLE, TL.INVOICE_NAME INVOICE_NAME, TL.DESCRIPTIVE_SIZE DESCRIPTIVE_SIZE, TL.FUNCTIONAL_NAME FUNCTIONAL_NAME, TL.TRADE_ITEM_FORM_DESCRIPTION TRADE_ITEM_FORM_DESCRIPTION, TL.WARRANTY_DESCRIPTION WARRANTY_DESCRIPTION, TL.TRADE_ITEM_FINISH_DESCRIPTION TRADE_ITEM_FINISH_DESCRIPTION, TL.DESCRIPTION_SHORT DESCRIPTION_SHORT, B.REQUEST_ID REQUEST_ID, B.CHANGE_ID CHANGE_ID, B.CHANGE_LINE_ID CHANGE_LINE_ID, B.ACD_TYPE ACD_TYPE, B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE FROM EGO_GTN_ATTR_CHG_B B, EGO_GTN_ATTR_CHG_TL TL WHERE B.EXTENSION_ID = TL.EXTENSION_ID AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID AND B.ACD_TYPE = TL.ACD_TYPE AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.EXTENSION_ID EXTENSION_ID
, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, B.REVISION_ID REVISION_ID
, B.IS_TRADE_ITEM_A_CONSUMER_UNIT IS_TRADE_ITEM_A_CONSUMER_UNIT
, B.IS_TRADE_ITEM_INFO_PRIVATE IS_TRADE_ITEM_INFO_PRIVATE
, B.GROSS_WEIGHT GROSS_WEIGHT
, B.UOM_GROSS_WEIGHT UOM_GROSS_WEIGHT
, B.EFFECTIVE_DATE EFFECTIVE_DATE
, B.CANCELED_DATE CANCELED_DATE
, B.DISCONTINUED_DATE DISCONTINUED_DATE
, B.END_AVAILABILITY_DATE_TIME END_AVAILABILITY_DATE_TIME
, B.START_AVAILABILITY_DATE_TIME START_AVAILABILITY_DATE_TIME
, B.BRAND_NAME BRAND_NAME
, B.IS_TRADE_ITEM_A_BASE_UNIT IS_TRADE_ITEM_A_BASE_UNIT
, B.IS_TRADE_ITEM_A_VARIABLE_UNIT IS_TRADE_ITEM_A_VARIABLE_UNIT
, B.IS_PACK_MARKED_WITH_EXP_DATE IS_PACK_MARKED_WITH_EXP_DATE
, B.IS_PACK_MARKED_WITH_GREEN_DOT IS_PACK_MARKED_WITH_GREEN_DOT
, B.IS_PACK_MARKED_WITH_INGRED IS_PACK_MARKED_WITH_INGRED
, B.IS_PACKAGE_MARKED_AS_REC IS_PACKAGE_MARKED_AS_REC
, B.IS_PACKAGE_MARKED_RET IS_PACKAGE_MARKED_RET
, B.STACKING_FACTOR STACKING_FACTOR
, B.STACKING_WEIGHT_MAXIMUM STACKING_WEIGHT_MAXIMUM
, B.UOM_STACKING_WEIGHT_MAXIMUM UOM_STACKING_WEIGHT_MAXIMUM
, B.ORDERING_LEAD_TIME ORDERING_LEAD_TIME
, B.UOM_ORDERING_LEAD_TIME UOM_ORDERING_LEAD_TIME
, B.ORDER_QUANTITY_MAX ORDER_QUANTITY_MAX
, B.ORDER_QUANTITY_MIN ORDER_QUANTITY_MIN
, B.ORDER_QUANTITY_MULTIPLE ORDER_QUANTITY_MULTIPLE
, B.ORDER_SIZING_FACTOR ORDER_SIZING_FACTOR
, B.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, B.CATALOG_PRICE CATALOG_PRICE
, B.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, B.SUGGESTED_RETAIL_PRICE SUGGESTED_RETAIL_PRICE
, B.MATERIAL_SAFETY_DATA_SHEET_NO MATERIAL_SAFETY_DATA_SHEET_NO
, B.HAS_BATCH_NUMBER HAS_BATCH_NUMBER
, B.IS_NON_SOLD_TRADE_RET_FLAG IS_NON_SOLD_TRADE_RET_FLAG
, B.IS_TRADE_ITEM_MAR_REC_FLAG IS_TRADE_ITEM_MAR_REC_FLAG
, B.DIAMETER DIAMETER
, B.UOM_DIAMETER UOM_DIAMETER
, B.DRAINED_WEIGHT DRAINED_WEIGHT
, B.UOM_DRAINED_WEIGHT UOM_DRAINED_WEIGHT
, B.GENERIC_INGREDIENT GENERIC_INGREDIENT
, B.GENERIC_INGREDIENT_STRGTH GENERIC_INGREDIENT_STRGTH
, B.UOM_GENERIC_INGREDIENT_STRGTH UOM_GENERIC_INGREDIENT_STRGTH
, B.INGREDIENT_STRENGTH INGREDIENT_STRENGTH
, B.IS_NET_CONTENT_DEC_FLAG IS_NET_CONTENT_DEC_FLAG
, B.NET_CONTENT NET_CONTENT
, B.UOM_NET_CONTENT UOM_NET_CONTENT
, B.PEG_HORIZONTAL PEG_HORIZONTAL
, B.UOM_PEG_HORIZONTAL UOM_PEG_HORIZONTAL
, B.PEG_VERTICAL PEG_VERTICAL
, B.UOM_PEG_VERTICAL UOM_PEG_VERTICAL
, B.CONSUMER_AVAIL_DATE_TIME CONSUMER_AVAIL_DATE_TIME
, B.DEL_TO_DIST_CNTR_TEMP_MAX DEL_TO_DIST_CNTR_TEMP_MAX
, B.UOM_DEL_TO_DIST_CNTR_TEMP_MAX UOM_DEL_TO_DIST_CNTR_TEMP_MAX
, B.DEL_TO_DIST_CNTR_TEMP_MIN DEL_TO_DIST_CNTR_TEMP_MIN
, B.UOM_DEL_TO_DIST_CNTR_TEMP_MIN UOM_DEL_TO_DIST_CNTR_TEMP_MIN
, B.DELIVERY_TO_MRKT_TEMP_MAX DELIVERY_TO_MRKT_TEMP_MAX
, B.UOM_DELIVERY_TO_MRKT_TEMP_MAX UOM_DELIVERY_TO_MRKT_TEMP_MAX
, B.DELIVERY_TO_MRKT_TEMP_MIN DELIVERY_TO_MRKT_TEMP_MIN
, B.UOM_DELIVERY_TO_MRKT_TEMP_MIN UOM_DELIVERY_TO_MRKT_TEMP_MIN
, B.SUB_BRAND SUB_BRAND
, B.TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR
, B.EANUCC_CODE EANUCC_CODE
, B.EANUCC_TYPE EANUCC_TYPE
, B.RETAIL_PRICE_ON_TRADE_ITEM RETAIL_PRICE_ON_TRADE_ITEM
, B.QUANTITY_OF_COMP_LAY_ITEM QUANTITY_OF_COMP_LAY_ITEM
, B.QUANITY_OF_ITEM_IN_LAYER QUANITY_OF_ITEM_IN_LAYER
, B.QUANTITY_OF_ITEM_INNER_PACK QUANTITY_OF_ITEM_INNER_PACK
, B.TARGET_MARKET_DESC TARGET_MARKET_DESC
, B.QUANTITY_OF_INNER_PACK QUANTITY_OF_INNER_PACK
, B.BRAND_OWNER_GLN BRAND_OWNER_GLN
, B.BRAND_OWNER_NAME BRAND_OWNER_NAME
, B.STORAGE_HANDLING_TEMP_MAX STORAGE_HANDLING_TEMP_MAX
, B.UOM_STORAGE_HANDLING_TEMP_MAX UOM_STORAGE_HANDLING_TEMP_MAX
, B.STORAGE_HANDLING_TEMP_MIN STORAGE_HANDLING_TEMP_MIN
, B.UOM_STORAGE_HANDLING_TEMP_MIN UOM_STORAGE_HANDLING_TEMP_MIN
, B.TRADE_ITEM_COUPON TRADE_ITEM_COUPON
, B.DEGREE_OF_ORIGINAL_WORT DEGREE_OF_ORIGINAL_WORT
, B.FAT_PERCENT_IN_DRY_MATTER FAT_PERCENT_IN_DRY_MATTER
, B.PERCENT_OF_ALCOHOL_BY_VOL PERCENT_OF_ALCOHOL_BY_VOL
, B.ISBN_NUMBER ISBN_NUMBER
, B.ISSN_NUMBER ISSN_NUMBER
, B.IS_INGREDIENT_IRRADIATED IS_INGREDIENT_IRRADIATED
, B.IS_RAW_MATERIAL_IRRADIATED IS_RAW_MATERIAL_IRRADIATED
, B.IS_TRADE_ITEM_GENETICALLY_MOD IS_TRADE_ITEM_GENETICALLY_MOD
, B.IS_TRADE_ITEM_IRRADIATED IS_TRADE_ITEM_IRRADIATED
, B.PUBLICATION_STATUS PUBLICATION_STATUS
, B.TOP_GTIN TOP_GTIN
, B.SECURITY_TAG_LOCATION SECURITY_TAG_LOCATION
, B.URL_FOR_WARRANTY URL_FOR_WARRANTY
, B.NESTING_INCREMENT NESTING_INCREMENT
, B.UOM_NESTING_INCREMENT UOM_NESTING_INCREMENT
, B.IS_TRADE_ITEM_RECALLED IS_TRADE_ITEM_RECALLED
, B.MODEL_NUMBER MODEL_NUMBER
, B.PIECES_PER_TRADE_ITEM PIECES_PER_TRADE_ITEM
, B.UOM_PIECES_PER_TRADE_ITEM UOM_PIECES_PER_TRADE_ITEM
, B.DEPT_OF_TRNSPRT_DANG_GOODS_NUM DEPT_OF_TRNSPRT_DANG_GOODS_NUM
, B.RETURN_GOODS_POLICY RETURN_GOODS_POLICY
, B.IS_OUT_OF_BOX_PROVIDED IS_OUT_OF_BOX_PROVIDED
, B.REGISTRATION_UPDATE_DATE REGISTRATION_UPDATE_DATE
, B.TP_NEUTRAL_UPDATE_DATE TP_NEUTRAL_UPDATE_DATE
, B.MASTER_ORG_EXTENSION_ID MASTER_ORG_EXTENSION_ID
, B.IS_BARCODE_SYMBOLOGY_DERIVABLE IS_BARCODE_SYMBOLOGY_DERIVABLE
, TL.INVOICE_NAME INVOICE_NAME
, TL.DESCRIPTIVE_SIZE DESCRIPTIVE_SIZE
, TL.FUNCTIONAL_NAME FUNCTIONAL_NAME
, TL.TRADE_ITEM_FORM_DESCRIPTION TRADE_ITEM_FORM_DESCRIPTION
, TL.WARRANTY_DESCRIPTION WARRANTY_DESCRIPTION
, TL.TRADE_ITEM_FINISH_DESCRIPTION TRADE_ITEM_FINISH_DESCRIPTION
, TL.DESCRIPTION_SHORT DESCRIPTION_SHORT
, B.REQUEST_ID REQUEST_ID
, B.CHANGE_ID CHANGE_ID
, B.CHANGE_LINE_ID CHANGE_LINE_ID
, B.ACD_TYPE ACD_TYPE
, B.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
FROM EGO_GTN_ATTR_CHG_B B
, EGO_GTN_ATTR_CHG_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID
AND B.ACD_TYPE = TL.ACD_TYPE
AND TL.LANGUAGE = USERENV('LANG')