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_STYLE_SKU_ITEM_PVT dependencies on DUAL

Line 199: l_dual_uom_deviation_high NUMBER ;

195: l_allowed_units_lookup_code NUMBER ;
196: l_tracking_quantity_ind VARCHAR2(30) ;
197: l_ont_pricing_qty_source VARCHAR2(30) ;
198: l_secondary_default_ind VARCHAR2(30) ;
199: l_dual_uom_deviation_high NUMBER ;
200: l_dual_uom_deviation_low NUMBER ;
201: l_secondary_uom_code VARCHAR2(3) ;
202: l_lifecycle_id NUMBER ;
203: l_current_phase_id NUMBER ;

Line 200: l_dual_uom_deviation_low NUMBER ;

196: l_tracking_quantity_ind VARCHAR2(30) ;
197: l_ont_pricing_qty_source VARCHAR2(30) ;
198: l_secondary_default_ind VARCHAR2(30) ;
199: l_dual_uom_deviation_high NUMBER ;
200: l_dual_uom_deviation_low NUMBER ;
201: l_secondary_uom_code VARCHAR2(3) ;
202: l_lifecycle_id NUMBER ;
203: l_current_phase_id NUMBER ;
204: l_item_catalog_group_id NUMBER ;

Line 240: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,

236: A.ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE ,
237: A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND ,
238: A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE ,
239: A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND ,
240: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,
241: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,
242: A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE ,
243: A.LIFECYCLE_ID LIFECYCLE_ID ,
244: A.CURRENT_PHASE_ID CURRENT_PHASE_ID ,

Line 241: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,

237: A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND ,
238: A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE ,
239: A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND ,
240: A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH ,
241: A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW ,
242: A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE ,
243: A.LIFECYCLE_ID LIFECYCLE_ID ,
244: A.CURRENT_PHASE_ID CURRENT_PHASE_ID ,
245: A.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID ,

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

253: A.GDSN_OUTBOUND_ENABLED_FLAG GDSN_OUTBOUND_ENABLED_FLAG ,
254: A.TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR ,
255: A.TRANSACTION_ID TRANSACTION_ID,
256: A.SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
257: FROM THE (SELECT CAST( p_Item_Intf_Data_Tab AS EGO_ITEM_INTF_DATA_TAB) FROM DUAL)
258: A;
259: BEGIN
260: FOR item_data_rec IN ITEM_DATA_RECS
261: LOOP

Line 280: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;

276: l_allowed_units_lookup_code := item_data_rec.ALLOWED_UNITS_LOOKUP_CODE ;
277: l_tracking_quantity_ind := item_data_rec.TRACKING_QUANTITY_IND ;
278: l_ont_pricing_qty_source := item_data_rec.ONT_PRICING_QTY_SOURCE ;
279: l_secondary_default_ind := item_data_rec.SECONDARY_DEFAULT_IND ;
280: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;
281: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;
282: l_secondary_uom_code := item_data_rec.SECONDARY_UOM_CODE ;
283: l_lifecycle_id := item_data_rec.LIFECYCLE_ID ;
284: l_current_phase_id := item_data_rec.CURRENT_PHASE_ID ;

Line 281: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;

277: l_tracking_quantity_ind := item_data_rec.TRACKING_QUANTITY_IND ;
278: l_ont_pricing_qty_source := item_data_rec.ONT_PRICING_QTY_SOURCE ;
279: l_secondary_default_ind := item_data_rec.SECONDARY_DEFAULT_IND ;
280: l_dual_uom_deviation_high := item_data_rec.DUAL_UOM_DEVIATION_HIGH ;
281: l_dual_uom_deviation_low := item_data_rec.DUAL_UOM_DEVIATION_LOW ;
282: l_secondary_uom_code := item_data_rec.SECONDARY_UOM_CODE ;
283: l_lifecycle_id := item_data_rec.LIFECYCLE_ID ;
284: l_current_phase_id := item_data_rec.CURRENT_PHASE_ID ;
285: l_item_catalog_group_id := item_data_rec.ITEM_CATALOG_GROUP_ID ;

Line 331: DUAL_UOM_DEVIATION_HIGH ,

327: ALLOWED_UNITS_LOOKUP_CODE ,
328: TRACKING_QUANTITY_IND ,
329: ONT_PRICING_QTY_SOURCE ,
330: SECONDARY_DEFAULT_IND ,
331: DUAL_UOM_DEVIATION_HIGH ,
332: DUAL_UOM_DEVIATION_LOW ,
333: SECONDARY_UOM_CODE ,
334: LIFECYCLE_ID ,
335: CURRENT_PHASE_ID ,

Line 332: DUAL_UOM_DEVIATION_LOW ,

328: TRACKING_QUANTITY_IND ,
329: ONT_PRICING_QTY_SOURCE ,
330: SECONDARY_DEFAULT_IND ,
331: DUAL_UOM_DEVIATION_HIGH ,
332: DUAL_UOM_DEVIATION_LOW ,
333: SECONDARY_UOM_CODE ,
334: LIFECYCLE_ID ,
335: CURRENT_PHASE_ID ,
336: ITEM_CATALOG_GROUP_ID ,

Line 370: l_dual_uom_deviation_high ,

366: l_allowed_units_lookup_code ,
367: l_tracking_quantity_ind ,
368: l_ont_pricing_qty_source ,
369: l_secondary_default_ind ,
370: l_dual_uom_deviation_high ,
371: l_dual_uom_deviation_low ,
372: l_secondary_uom_code ,
373: l_lifecycle_id ,
374: l_current_phase_id ,

Line 371: l_dual_uom_deviation_low ,

367: l_tracking_quantity_ind ,
368: l_ont_pricing_qty_source ,
369: l_secondary_default_ind ,
370: l_dual_uom_deviation_high ,
371: l_dual_uom_deviation_low ,
372: l_secondary_uom_code ,
373: l_lifecycle_id ,
374: l_current_phase_id ,
375: l_item_catalog_group_id ,

Line 666: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL

662: FROM MTL_ITEM_CATALOG_GROUPS_B
663: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
664: START WITH ITEM_CATALOG_GROUP_ID = p_parent_catalog_group_id
665: UNION ALL
666: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL
667: );
668: BEGIN
669: SELECT OBJECT_ID INTO l_itm_obj_id
670: FROM FND_OBJECTS