Product: | EGO - Advanced Product Catalog |
---|---|
Description: | This view stores pending changes information for GDSN single row attributes |
Implementation/DBA Data: | APPS.EGO_GTN_ATTR_CHG_VL |
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')