[Home] [Help]
46: END IF;
47: --Begin Bug16344740
48: BEGIN
49: SELECT NVL(process_enabled_flag, 'N') INTO l_process_enabled_flag
50: FROM mtl_parameters
51: WHERE organization_id = p_organization_id;
52: EXCEPTION
53: WHEN NO_DATA_FOUND THEN
54: l_process_enabled_flag := 'N';
107: BEGIN
108: SELECT NVL ( ccicv.item_cost, 0 )
109: INTO x_item_cost
110: FROM cst_cg_item_costs_view ccicv,
111: mtl_parameters mp
112: WHERE l_locator_id IS NULL
113: AND ccicv.organization_id = p_organization_id
114: AND ccicv.inventory_item_id = p_inventory_item_id
115: AND ccicv.organization_id = mp.organization_id
121: UNION ALL
122: SELECT NVL ( ccicv.item_cost, 0 )
123: FROM mtl_item_locations mil,
124: cst_cg_item_costs_view ccicv,
125: mtl_parameters mp
126: WHERE l_locator_id IS NOT NULL
127: AND mil.organization_id = p_organization_id
128: AND mil.inventory_location_id = l_locator_id
129: AND mil.project_id IS NULL
139: SELECT NVL ( ccicv.item_cost, 0 )
140: FROM mtl_item_locations mil,
141: mrp_project_parameters mrp,
142: cst_cg_item_costs_view ccicv,
143: mtl_parameters mp
144: WHERE l_locator_id IS NOT NULL
145: AND mil.organization_id = p_organization_id
146: AND mil.inventory_location_id = l_locator_id
147: AND mil.project_id IS NOT NULL
6295: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6296: BEGIN
6297: SELECT SERIAL_NUMBER_TYPE
6298: INTO l_serial_number_type
6299: FROM MTL_PARAMETERS
6300: WHERE organization_id = MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID;
6301:
6302: mtl_serial_check.inv_qtybetwn(
6303: p_api_version => 0.9,
6392: else
6393: if(v_org_id IS NOT NULL) then
6394: SELECT SERIAL_NUMBER_TYPE
6395: INTO v_serial_number_type
6396: FROM MTL_PARAMETERS
6397: WHERE ORGANIZATION_ID = v_org_id;
6398: end if;
6399: u1 := v_serial_number ;
6400: u2 := v_serial_number ;