APPS.EGO_ITEM_PUB dependencies on EGO_ITEM_GTN_ATTRS_VL

Line 666: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE

662: TYPE UCCnet_Attrs_Singl_Row_Rec_Typ IS RECORD(
663: TRANSACTION_TYPE VARCHAR2(30)
664: ,RETURN_STATUS VARCHAR2(1)
665: ,LANGUAGE_CODE VARCHAR2(4)
666: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE

Line 667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE

663: TRANSACTION_TYPE VARCHAR2(30)
664: ,RETURN_STATUS VARCHAR2(1)
665: ,LANGUAGE_CODE VARCHAR2(4)
666: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE

Line 669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE

665: ,LANGUAGE_CODE VARCHAR2(4)
666: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE

Line 670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE

666: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE

Line 671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE

667: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE

Line 672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE

668: ,GROSS_WEIGHT NUMBER
669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE

Line 673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE

669: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE

Line 674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE

670: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE

Line 675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE

671: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE

Line 676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE

672: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE

Line 677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE

673: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
681: ,STACKING_FACTOR NUMBER

Line 678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE

674: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
681: ,STACKING_FACTOR NUMBER
682: ,STACKING_WEIGHT_MAXIMUM NUMBER

Line 679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE

675: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
681: ,STACKING_FACTOR NUMBER
682: ,STACKING_WEIGHT_MAXIMUM NUMBER
683: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE

Line 680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE

676: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
677: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
678: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
681: ,STACKING_FACTOR NUMBER
682: ,STACKING_WEIGHT_MAXIMUM NUMBER
683: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
684: ,ORDERING_LEAD_TIME NUMBER

Line 683: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE

679: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
680: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
681: ,STACKING_FACTOR NUMBER
682: ,STACKING_WEIGHT_MAXIMUM NUMBER
683: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
684: ,ORDERING_LEAD_TIME NUMBER
685: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE
686: ,ORDER_QUANTITY_MAX NUMBER
687: ,ORDER_QUANTITY_MIN NUMBER

Line 685: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE

681: ,STACKING_FACTOR NUMBER
682: ,STACKING_WEIGHT_MAXIMUM NUMBER
683: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
684: ,ORDERING_LEAD_TIME NUMBER
685: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE
686: ,ORDER_QUANTITY_MAX NUMBER
687: ,ORDER_QUANTITY_MIN NUMBER
688: ,ORDER_QUANTITY_MULTIPLE NUMBER
689: ,ORDER_SIZING_FACTOR NUMBER

Line 690: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE

686: ,ORDER_QUANTITY_MAX NUMBER
687: ,ORDER_QUANTITY_MIN NUMBER
688: ,ORDER_QUANTITY_MULTIPLE NUMBER
689: ,ORDER_SIZING_FACTOR NUMBER
690: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
691: ,CATALOG_PRICE NUMBER
692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE

Line 692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE

688: ,ORDER_QUANTITY_MULTIPLE NUMBER
689: ,ORDER_SIZING_FACTOR NUMBER
690: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
691: ,CATALOG_PRICE NUMBER
692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE

Line 694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE

690: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
691: ,CATALOG_PRICE NUMBER
692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER

Line 695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE

691: ,CATALOG_PRICE NUMBER
692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE

Line 696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE

692: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
700: ,DRAINED_WEIGHT NUMBER

Line 697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE

693: ,SUGGESTED_RETAIL_PRICE NUMBER
694: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
700: ,DRAINED_WEIGHT NUMBER
701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE

Line 699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE

695: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
696: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
700: ,DRAINED_WEIGHT NUMBER
701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER

Line 701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE

697: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
700: ,DRAINED_WEIGHT NUMBER
701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER
704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE

Line 702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE

698: ,DIAMETER NUMBER
699: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
700: ,DRAINED_WEIGHT NUMBER
701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER
704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE

Line 704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE

700: ,DRAINED_WEIGHT NUMBER
701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER
704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
707: ,NET_CONTENT NUMBER
708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE

Line 705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE

701: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER
704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
707: ,NET_CONTENT NUMBER
708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
709: ,PEG_HORIZONTAL NUMBER

Line 706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE

702: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
703: ,GENERIC_INGREDIENT_STRGTH NUMBER
704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
707: ,NET_CONTENT NUMBER
708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
709: ,PEG_HORIZONTAL NUMBER
710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE

Line 708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE

704: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
705: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
707: ,NET_CONTENT NUMBER
708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
709: ,PEG_HORIZONTAL NUMBER
710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
711: ,PEG_VERTICAL NUMBER
712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE

Line 710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE

706: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
707: ,NET_CONTENT NUMBER
708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
709: ,PEG_HORIZONTAL NUMBER
710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
711: ,PEG_VERTICAL NUMBER
712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
714: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER

Line 712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE

708: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
709: ,PEG_HORIZONTAL NUMBER
710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
711: ,PEG_VERTICAL NUMBER
712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
714: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
716: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER

Line 713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE

709: ,PEG_HORIZONTAL NUMBER
710: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
711: ,PEG_VERTICAL NUMBER
712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
714: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
716: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE

Line 715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE

711: ,PEG_VERTICAL NUMBER
712: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
714: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
716: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
718: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE

Line 717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE

713: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
714: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
716: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
718: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE

Line 719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE

715: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
716: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
718: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE

Line 721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE

717: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
718: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE

Line 722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE

718: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
726: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER

Line 723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE

719: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
726: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
727: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER

Line 724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE

720: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
726: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
727: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
728: ,QUANITY_OF_ITEM_IN_LAYER NUMBER

Line 725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE

721: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
722: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
723: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
724: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
725: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
726: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
727: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
728: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
729: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER

Line 731: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE

727: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
728: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
729: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER
730: ,QUANTITY_OF_INNER_PACK NUMBER
731: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
732: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
733: ,STORAGE_HANDLING_TEMP_MAX NUMBER
734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
735: ,STORAGE_HANDLING_TEMP_MIN NUMBER

Line 732: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE

728: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
729: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER
730: ,QUANTITY_OF_INNER_PACK NUMBER
731: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
732: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
733: ,STORAGE_HANDLING_TEMP_MAX NUMBER
734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
735: ,STORAGE_HANDLING_TEMP_MIN NUMBER
736: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE

Line 734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE

730: ,QUANTITY_OF_INNER_PACK NUMBER
731: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
732: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
733: ,STORAGE_HANDLING_TEMP_MAX NUMBER
734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
735: ,STORAGE_HANDLING_TEMP_MIN NUMBER
736: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
737: ,TRADE_ITEM_COUPON NUMBER
738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE

Line 736: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE

732: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
733: ,STORAGE_HANDLING_TEMP_MAX NUMBER
734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
735: ,STORAGE_HANDLING_TEMP_MIN NUMBER
736: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
737: ,TRADE_ITEM_COUPON NUMBER
738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
739: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER

Line 738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE

734: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
735: ,STORAGE_HANDLING_TEMP_MIN NUMBER
736: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
737: ,TRADE_ITEM_COUPON NUMBER
738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
739: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE

Line 741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE

737: ,TRADE_ITEM_COUPON NUMBER
738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
739: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE

Line 742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE

738: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
739: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE

Line 743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE

739: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE

Line 744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE

740: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE

Line 745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE

741: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER

Line 746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE

742: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE

Line 747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE

743: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE

Line 748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE

744: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
745: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE

Line 750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE

746: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE

Line 751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE

747: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE

Line 752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE

748: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
749: ,NESTING_INCREMENT NUMBER
750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE

Line 754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE

750: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE

Line 755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE

751: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE

Line 756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE

752: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE

Line 757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE

753: ,PIECES_PER_TRADE_ITEM NUMBER
754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE

Line 758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE

754: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE

Line 759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE

755: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE

Line 760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE

756: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE

Line 761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE

757: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE

Line 762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE

758: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
766: );

Line 763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE

759: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
766: );
767:

Line 764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE

760: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
766: );
767:
768: TYPE UCCnet_Attrs_Multi_Row_Rec_Typ IS RECORD(

Line 765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE

761: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
762: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
763: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
764: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
765: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
766: );
767:
768: TYPE UCCnet_Attrs_Multi_Row_Rec_Typ IS RECORD(
769: EXTENSION_ID NUMBER