APPS.INV_UTILITIES dependencies on DUAL

Line 219: FROM DUAL;

215: END IF;
216:
217: SELECT mtl_material_transactions_s.NEXTVAL
218: INTO v_header_id
219: FROM DUAL;
220:
221: inv_replenish_detail_pub.line_details_pub(
222: p_line_id => v_line_id
223: , x_number_of_rows => v_num_of_rows

Line 480: FROM dual

476: --13825283
477: begin
478:
479: SELECT 'N' INTO v_all_expense_flag
480: FROM dual
481: WHERE EXISTS ( SELECT 1
482: FROM po_distributions_all pod
483: WHERE pod.destination_type_code <> 'EXPENSE'
484: AND pod.line_location_id = p_po_line_location_id);

Line 877: by calling API OE_DUAL_UOM_UTIL.get_fulfillment_base.

873:
874: /*
875: This API was created as a part of MUOM fulfillment ER.
876: This will accept source_line_id as input paramter and will return the fulfillment_base
877: by calling API OE_DUAL_UOM_UTIL.get_fulfillment_base.
878: */
879: PROCEDURE get_inv_fulfillment_base(
880: p_source_line_id IN NUMBER,
881: p_demand_source_type_id IN NUMBER,

Line 898: x_fulfillment_base := Nvl(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_source_line_id), 'P');

894: END IF;
895:
896: IF l_is_wms_enabled = 'Y' THEN
897: IF p_demand_source_type_id IN (2,8) THEN
898: x_fulfillment_base := Nvl(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_source_line_id), 'P');
899: IF (l_debug = 1) THEN
900: inv_log_util.TRACE('The fulfillment Base: '||x_fulfillment_base , 'INV_UTILITIES', 9);
901: END IF;
902: ELSE