eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_ITEM_GTN_ATTRS_VL

Line 292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ

288: l_conversion_error EXCEPTION;
289: PRAGMA EXCEPTION_INIT(l_conversion_error, -6502);
290: l_attr_name VARCHAR2(1000);
291:
292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
293: -- contains the type of these columns as NUMBER
294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;

Line 295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;

291:
292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
293: -- contains the type of these columns as NUMBER
294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;

Line 296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;

292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
293: -- contains the type of these columns as NUMBER
294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;

Line 297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;

293: -- contains the type of these columns as NUMBER
294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;

Line 298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;

294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;

Line 299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;

295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;

Line 300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;

296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;
297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;

Line 301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;

297: l_stacking_weight_maximum EGO_ITEM_GTN_ATTRS_VL.STACKING_WEIGHT_MAXIMUM%TYPE;
298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;

Line 302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;

298: l_ordering_lead_time EGO_ITEM_GTN_ATTRS_VL.ORDERING_LEAD_TIME%TYPE;
299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;

Line 303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;

299: l_order_quantity_max EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MAX%TYPE;
300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;

Line 304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;

300: l_order_quantity_min EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MIN%TYPE;
301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;

Line 305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;

301: l_order_quantity_multiple EGO_ITEM_GTN_ATTRS_VL.ORDER_QUANTITY_MULTIPLE%TYPE;
302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;

Line 306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;

302: l_order_sizing_factor EGO_ITEM_GTN_ATTRS_VL.ORDER_SIZING_FACTOR%TYPE;
303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;

Line 307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;

303: l_catalog_price EGO_ITEM_GTN_ATTRS_VL.CATALOG_PRICE%TYPE;
304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;

Line 308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;

304: l_suggested_retail_price EGO_ITEM_GTN_ATTRS_VL.SUGGESTED_RETAIL_PRICE%TYPE;
305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;

Line 309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;

305: l_diameter EGO_ITEM_GTN_ATTRS_VL.DIAMETER%TYPE;
306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;

Line 310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;

306: l_drained_weight EGO_ITEM_GTN_ATTRS_VL.DRAINED_WEIGHT%TYPE;
307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;

Line 311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;

307: l_generic_ingredient_strgth EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT_STRGTH%TYPE;
308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;

Line 312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;

308: l_net_content EGO_ITEM_GTN_ATTRS_VL.NET_CONTENT%TYPE;
309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;

Line 313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;

309: l_peg_horizontal EGO_ITEM_GTN_ATTRS_VL.PEG_HORIZONTAL%TYPE;
310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;

Line 314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;

310: l_peg_vertical EGO_ITEM_GTN_ATTRS_VL.PEG_VERTICAL%TYPE;
311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;

Line 315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;

311: l_del_to_dist_cntr_temp_max EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MAX%TYPE;
312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;

Line 316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;

312: l_del_to_dist_cntr_temp_min EGO_ITEM_GTN_ATTRS_VL.DEL_TO_DIST_CNTR_TEMP_MIN%TYPE;
313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;

Line 317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;

313: l_delivery_to_mrkt_temp_max EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MAX%TYPE;
314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;

Line 318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;

314: l_delivery_to_mrkt_temp_min EGO_ITEM_GTN_ATTRS_VL.DELIVERY_TO_MRKT_TEMP_MIN%TYPE;
315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;

Line 319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;

315: l_retail_price_on_trade_item EGO_ITEM_GTN_ATTRS_VL.RETAIL_PRICE_ON_TRADE_ITEM%TYPE;
316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;

Line 320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;

316: l_quantity_of_comp_lay_item EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_COMP_LAY_ITEM%TYPE;
317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;

Line 321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;

317: l_quanity_of_item_in_layer EGO_ITEM_GTN_ATTRS_VL.QUANITY_OF_ITEM_IN_LAYER%TYPE;
318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;

Line 322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;

318: l_quantity_of_item_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_ITEM_INNER_PACK%TYPE;
319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;

Line 323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;

319: l_quantity_of_inner_pack EGO_ITEM_GTN_ATTRS_VL.QUANTITY_OF_INNER_PACK%TYPE;
320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:

Line 324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;

320: l_storage_handling_temp_max EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MAX%TYPE;
321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:
328:

Line 325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;

321: l_storage_handling_temp_min EGO_ITEM_GTN_ATTRS_VL.STORAGE_HANDLING_TEMP_MIN%TYPE;
322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:
328:
329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ

Line 326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;

322: l_trade_item_coupon EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_COUPON%TYPE;
323: l_fat_percent_in_dry_matter EGO_ITEM_GTN_ATTRS_VL.FAT_PERCENT_IN_DRY_MATTER%TYPE;
324: l_percent_of_alcohol_by_vol EGO_ITEM_GTN_ATTRS_VL.PERCENT_OF_ALCOHOL_BY_VOL%TYPE;
325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:
328:
329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
330: -- contains the type of these columns as NUMBER

Line 1839: FROM EGO_ITEM_GTN_ATTRS_VL gtn, MTL_SYSTEM_ITEMS_B msib

1835: ,gtn.PEG_HORIZONTAL
1836: ,gtn.PEG_VERTICAL
1837: ,gtn.GENERIC_INGREDIENT
1838: ,gtn.UOM_NET_CONTENT
1839: FROM EGO_ITEM_GTN_ATTRS_VL gtn, MTL_SYSTEM_ITEMS_B msib
1840: WHERE gtn.INVENTORY_ITEM_ID(+) = msib.INVENTORY_ITEM_ID
1841: AND gtn.ORGANIZATION_ID(+) = msib.ORGANIZATION_ID
1842: AND msib.INVENTORY_ITEM_ID = p_inventory_item_id
1843: AND msib.ORGANIZATION_ID = p_organization_id;