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.

[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on DUAL

Line 243: l_dual_uom_deviation_high NUMBER ;

239: l_allowed_units_lookup_code NUMBER ;
240: l_tracking_quantity_ind VARCHAR2(30) ;
241: l_ont_pricing_qty_source VARCHAR2(30) ;
242: l_secondary_default_ind VARCHAR2(30) ;
243: l_dual_uom_deviation_high NUMBER ;
244: l_dual_uom_deviation_low NUMBER ;
245: l_secondary_uom_code VARCHAR2(3) ;
246: l_lifecycle_id NUMBER ;
247: l_current_phase_id NUMBER ;

Line 244: l_dual_uom_deviation_low NUMBER ;

240: l_tracking_quantity_ind VARCHAR2(30) ;
241: l_ont_pricing_qty_source VARCHAR2(30) ;
242: l_secondary_default_ind VARCHAR2(30) ;
243: l_dual_uom_deviation_high NUMBER ;
244: l_dual_uom_deviation_low NUMBER ;
245: l_secondary_uom_code VARCHAR2(3) ;
246: l_lifecycle_id NUMBER ;
247: l_current_phase_id NUMBER ;
248: l_item_catalog_group_id NUMBER ;

Line 285: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,

281: A.ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE ,
282: A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND ,
283: A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE ,
284: A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND ,
285: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,
286: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,
287: A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE ,
288: A.LIFECYCLE_ID LIFECYCLE_ID ,
289: A.CURRENT_PHASE_ID CURRENT_PHASE_ID ,

Line 286: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,

282: A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND ,
283: A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE ,
284: A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND ,
285: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,
286: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,
287: A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE ,
288: A.LIFECYCLE_ID LIFECYCLE_ID ,
289: A.CURRENT_PHASE_ID CURRENT_PHASE_ID ,
290: A.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID ,

Line 302: FROM THE (SELECT CAST( p_Item_Intf_Data_Tab AS EGO_ITEM_INTF_DATA_TAB) FROM DUAL)

298: A.GDSN_OUTBOUND_ENABLED_FLAG GDSN_OUTBOUND_ENABLED_FLAG ,
299: A.TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR ,
300: A.TRANSACTION_ID TRANSACTION_ID,
301: A.SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
302: FROM THE (SELECT CAST( p_Item_Intf_Data_Tab AS EGO_ITEM_INTF_DATA_TAB) FROM DUAL)
303: A;
304: BEGIN
305: FOR item_data_rec IN ITEM_DATA_RECS
306: LOOP

Line 325: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;

321: l_allowed_units_lookup_code := item_data_rec.ALLOWED_UNITS_LOOKUP_CODE ;
322: l_tracking_quantity_ind := item_data_rec.TRACKING_QUANTITY_IND ;
323: l_ont_pricing_qty_source := item_data_rec.ONT_PRICING_QTY_SOURCE ;
324: l_secondary_default_ind := item_data_rec.SECONDARY_DEFAULT_IND ;
325: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;
326: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;
327: l_secondary_uom_code := item_data_rec.SECONDARY_UOM_CODE ;
328: l_lifecycle_id := item_data_rec.LIFECYCLE_ID ;
329: l_current_phase_id := item_data_rec.CURRENT_PHASE_ID ;

Line 326: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;

322: l_tracking_quantity_ind := item_data_rec.TRACKING_QUANTITY_IND ;
323: l_ont_pricing_qty_source := item_data_rec.ONT_PRICING_QTY_SOURCE ;
324: l_secondary_default_ind := item_data_rec.SECONDARY_DEFAULT_IND ;
325: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;
326: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;
327: l_secondary_uom_code := item_data_rec.SECONDARY_UOM_CODE ;
328: l_lifecycle_id := item_data_rec.LIFECYCLE_ID ;
329: l_current_phase_id := item_data_rec.CURRENT_PHASE_ID ;
330: l_item_catalog_group_id := item_data_rec.ITEM_CATALOG_GROUP_ID ;

Line 376: DUAL_UOM_DEVIATION_HIGH ,

372: ALLOWED_UNITS_LOOKUP_CODE ,
373: TRACKING_QUANTITY_IND ,
374: ONT_PRICING_QTY_SOURCE ,
375: SECONDARY_DEFAULT_IND ,
376: DUAL_UOM_DEVIATION_HIGH ,
377: DUAL_UOM_DEVIATION_LOW ,
378: SECONDARY_UOM_CODE ,
379: LIFECYCLE_ID ,
380: CURRENT_PHASE_ID ,

Line 377: DUAL_UOM_DEVIATION_LOW ,

373: TRACKING_QUANTITY_IND ,
374: ONT_PRICING_QTY_SOURCE ,
375: SECONDARY_DEFAULT_IND ,
376: DUAL_UOM_DEVIATION_HIGH ,
377: DUAL_UOM_DEVIATION_LOW ,
378: SECONDARY_UOM_CODE ,
379: LIFECYCLE_ID ,
380: CURRENT_PHASE_ID ,
381: ITEM_CATALOG_GROUP_ID ,

Line 415: l_dual_uom_deviation_high ,

411: l_allowed_units_lookup_code ,
412: l_tracking_quantity_ind ,
413: l_ont_pricing_qty_source ,
414: l_secondary_default_ind ,
415: l_dual_uom_deviation_high ,
416: l_dual_uom_deviation_low ,
417: l_secondary_uom_code ,
418: l_lifecycle_id ,
419: l_current_phase_id ,

Line 416: l_dual_uom_deviation_low ,

412: l_tracking_quantity_ind ,
413: l_ont_pricing_qty_source ,
414: l_secondary_default_ind ,
415: l_dual_uom_deviation_high ,
416: l_dual_uom_deviation_low ,
417: l_secondary_uom_code ,
418: l_lifecycle_id ,
419: l_current_phase_id ,
420: l_item_catalog_group_id ,

Line 730: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL

726: FROM MTL_ITEM_CATALOG_GROUPS_B
727: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
728: START WITH ITEM_CATALOG_GROUP_ID = p_parent_catalog_group_id
729: UNION ALL
730: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL
731: );
732:
733: CURSOR IS_ICC_EXIST_FOR_STYLE(l_catalog_group_id NUMBER, l_flag VARCHAR2) IS
734: SELECT 1