APPS.EGO_ITEM_PUB dependencies on EGO_ITEM_GTN_ATTRS_VL

Line 660: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE

656: TYPE UCCnet_Attrs_Singl_Row_Rec_Typ IS RECORD(
657: TRANSACTION_TYPE VARCHAR2(30)
658: ,RETURN_STATUS VARCHAR2(1)
659: ,LANGUAGE_CODE VARCHAR2(4)
660: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE

Line 661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE

657: TRANSACTION_TYPE VARCHAR2(30)
658: ,RETURN_STATUS VARCHAR2(1)
659: ,LANGUAGE_CODE VARCHAR2(4)
660: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE

Line 663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE

659: ,LANGUAGE_CODE VARCHAR2(4)
660: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE

Line 664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE

660: ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE

Line 665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE

661: ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE

Line 666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE

662: ,GROSS_WEIGHT NUMBER
663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE

Line 667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE

663: ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE

Line 668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE

664: ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE

Line 669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE

665: ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE

Line 670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE

666: ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE

Line 671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE

667: ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675: ,STACKING_FACTOR NUMBER

Line 672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE

668: ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675: ,STACKING_FACTOR NUMBER
676: ,STACKING_WEIGHT_MAXIMUM NUMBER

Line 673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE

669: ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675: ,STACKING_FACTOR NUMBER
676: ,STACKING_WEIGHT_MAXIMUM NUMBER
677: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE

Line 674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE

670: ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671: ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672: ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675: ,STACKING_FACTOR NUMBER
676: ,STACKING_WEIGHT_MAXIMUM NUMBER
677: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
678: ,ORDERING_LEAD_TIME NUMBER

Line 677: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE

673: ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674: ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675: ,STACKING_FACTOR NUMBER
676: ,STACKING_WEIGHT_MAXIMUM NUMBER
677: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
678: ,ORDERING_LEAD_TIME NUMBER
679: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE
680: ,ORDER_QUANTITY_MAX NUMBER
681: ,ORDER_QUANTITY_MIN NUMBER

Line 679: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE

675: ,STACKING_FACTOR NUMBER
676: ,STACKING_WEIGHT_MAXIMUM NUMBER
677: ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
678: ,ORDERING_LEAD_TIME NUMBER
679: ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE
680: ,ORDER_QUANTITY_MAX NUMBER
681: ,ORDER_QUANTITY_MIN NUMBER
682: ,ORDER_QUANTITY_MULTIPLE NUMBER
683: ,ORDER_SIZING_FACTOR NUMBER

Line 684: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE

680: ,ORDER_QUANTITY_MAX NUMBER
681: ,ORDER_QUANTITY_MIN NUMBER
682: ,ORDER_QUANTITY_MULTIPLE NUMBER
683: ,ORDER_SIZING_FACTOR NUMBER
684: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
685: ,CATALOG_PRICE NUMBER
686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE

Line 686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE

682: ,ORDER_QUANTITY_MULTIPLE NUMBER
683: ,ORDER_SIZING_FACTOR NUMBER
684: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
685: ,CATALOG_PRICE NUMBER
686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE

Line 688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE

684: ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
685: ,CATALOG_PRICE NUMBER
686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER

Line 689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE

685: ,CATALOG_PRICE NUMBER
686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE

Line 690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE

686: ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694: ,DRAINED_WEIGHT NUMBER

Line 691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE

687: ,SUGGESTED_RETAIL_PRICE NUMBER
688: ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694: ,DRAINED_WEIGHT NUMBER
695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE

Line 693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE

689: ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690: ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694: ,DRAINED_WEIGHT NUMBER
695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER

Line 695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE

691: ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694: ,DRAINED_WEIGHT NUMBER
695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER
698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE

Line 696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE

692: ,DIAMETER NUMBER
693: ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694: ,DRAINED_WEIGHT NUMBER
695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER
698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE

Line 698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE

694: ,DRAINED_WEIGHT NUMBER
695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER
698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
701: ,NET_CONTENT NUMBER
702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE

Line 699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE

695: ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER
698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
701: ,NET_CONTENT NUMBER
702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703: ,PEG_HORIZONTAL NUMBER

Line 700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE

696: ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697: ,GENERIC_INGREDIENT_STRGTH NUMBER
698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
701: ,NET_CONTENT NUMBER
702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703: ,PEG_HORIZONTAL NUMBER
704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE

Line 702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE

698: ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699: ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
701: ,NET_CONTENT NUMBER
702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703: ,PEG_HORIZONTAL NUMBER
704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
705: ,PEG_VERTICAL NUMBER
706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE

Line 704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE

700: ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
701: ,NET_CONTENT NUMBER
702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703: ,PEG_HORIZONTAL NUMBER
704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
705: ,PEG_VERTICAL NUMBER
706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER

Line 706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE

702: ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703: ,PEG_HORIZONTAL NUMBER
704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
705: ,PEG_VERTICAL NUMBER
706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER

Line 707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE

703: ,PEG_HORIZONTAL NUMBER
704: ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
705: ,PEG_VERTICAL NUMBER
706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE

Line 709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE

705: ,PEG_VERTICAL NUMBER
706: ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
712: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE

Line 711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE

707: ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708: ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
712: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE

Line 713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE

709: ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710: ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
712: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE

Line 715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE

711: ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
712: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE

Line 716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE

712: ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
720: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER

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

713: ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
720: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
721: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER

Line 718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE

714: ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
720: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
721: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
722: ,QUANITY_OF_ITEM_IN_LAYER NUMBER

Line 719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE

715: ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716: ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717: -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718: ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719: ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
720: ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
721: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
722: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
723: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER

Line 725: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE

721: ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
722: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
723: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER
724: ,QUANTITY_OF_INNER_PACK NUMBER
725: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
726: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
727: ,STORAGE_HANDLING_TEMP_MAX NUMBER
728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729: ,STORAGE_HANDLING_TEMP_MIN NUMBER

Line 726: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE

722: ,QUANITY_OF_ITEM_IN_LAYER NUMBER
723: ,QUANTITY_OF_ITEM_INNER_PACK NUMBER
724: ,QUANTITY_OF_INNER_PACK NUMBER
725: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
726: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
727: ,STORAGE_HANDLING_TEMP_MAX NUMBER
728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729: ,STORAGE_HANDLING_TEMP_MIN NUMBER
730: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE

Line 728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE

724: ,QUANTITY_OF_INNER_PACK NUMBER
725: ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
726: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
727: ,STORAGE_HANDLING_TEMP_MAX NUMBER
728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729: ,STORAGE_HANDLING_TEMP_MIN NUMBER
730: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
731: ,TRADE_ITEM_COUPON NUMBER
732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE

Line 730: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE

726: ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
727: ,STORAGE_HANDLING_TEMP_MAX NUMBER
728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729: ,STORAGE_HANDLING_TEMP_MIN NUMBER
730: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
731: ,TRADE_ITEM_COUPON NUMBER
732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
733: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER

Line 732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE

728: ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729: ,STORAGE_HANDLING_TEMP_MIN NUMBER
730: ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
731: ,TRADE_ITEM_COUPON NUMBER
732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
733: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE

Line 735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE

731: ,TRADE_ITEM_COUPON NUMBER
732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
733: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE

Line 736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE

732: ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
733: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE

Line 737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE

733: ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE

Line 738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE

734: ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE

Line 739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE

735: ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER

Line 740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE

736: ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE

Line 741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE

737: ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE

Line 742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE

738: ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739: ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE

Line 744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE

740: ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE

Line 745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE

741: ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE

Line 746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE

742: ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743: ,NESTING_INCREMENT NUMBER
744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE

Line 748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE

744: ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE

Line 749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE

745: ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE

Line 750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE

746: ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE

Line 751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE

747: ,PIECES_PER_TRADE_ITEM NUMBER
748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE

Line 752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE

748: ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE

Line 753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE

749: ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE

Line 754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE

750: ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE

Line 755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE

751: ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE

Line 756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE

752: ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
760: );

Line 757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE

753: ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
760: );
761:

Line 758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE

754: ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
760: );
761:
762: TYPE UCCnet_Attrs_Multi_Row_Rec_Typ IS RECORD(

Line 759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE

755: ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756: ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757: ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758: ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759: ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
760: );
761:
762: TYPE UCCnet_Attrs_Multi_Row_Rec_Typ IS RECORD(
763: EXTENSION_ID NUMBER